Why can't I create a new table??

[MastahUK]

Creating tables in a database is something I have done before, and it worked fine. Now, I have tried copying the code that works perfectly and changing the values and I have also tried making a table with the same layout that I am after in phpMyAdmin and then copying and pasting the php code it outputs.

Both of these return this error:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '236 ( id INT NOT NULL AUTO_INCREMENT , name TINYTEXT NOT

Here is the code I am using to try and create the table:

	include "gfxconfig.php";

mysql_query (" 
CREATE TABLE $image (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` TINYTEXT NOT NULL ,
`email` TINYTEXT NOT NULL ,
`comment` TEXT NOT NULL ,
`sendtime` TINYTEXT NOT NULL ,
PRIMARY KEY ( `id` ) )
 ")  or die (mysql_error());

What am I doing wrong?

[barand]

Are you sure $image contains a valid table name?

[MastahUK]

Err.....I don't know. $image is a 3 digit number. I wasn't aware some table names were invalid.

[MastahUK]

It turns out it wasn't valid. I have fixed it now by doing this:

	include "gfxconfig.php";
	$table = "image" . $image;
	mysql_query (" 
	CREATE TABLE $table (
	`id` INT NOT NULL AUTO_INCREMENT ,
	`name` TINYTEXT NOT NULL ,
	`email` TINYTEXT NOT NULL ,
	`comment` TEXT NOT NULL ,
	`sendtime` TINYTEXT NOT NULL ,
	PRIMARY KEY ( `id` ) )
	 ")  or die (mysql_error());