PHP 4.0 Bug #7752 Updated: Will not create a new table in database

ID: 7752 Updated by: sniper Reported By: mgrigajtis@rosasonline.com Status: Closed Bug Type: MySQL related Assigned To: Comments: Your script is buggy, below correct line: $query = "CREATE TABLE $name (ID int(4), Date varchar(50), Sales float(4))"; You had ; before " as it should be after..typo? And do not add ; to mysql query strings in PHP. --Jani Previous Comments: --------------------------------------------------------------------------- [2000-11-10 14:09:55] mgrigajtis@rosasonline.com PHP4 will not ever create a new table in any database. It will create a new database, but just simply will not create the table. For example, the following lines do not work: $query = "CREATE TABLE $name (ID int(4), Date varchar(50), Sales float(4));" $result = mysql_query ($query); --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=7752