Creating a table in php problem...

[Jacbey]

Hi guys, i cannot figure out what is wrong with this and I hope you could help figure it out?

 

This is the code I am using -

 

$create_cart_table = "CREATE TABLE `". $string ."` (cart_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY(cart_id), item_name VARCHAR(1000) NOT NULL, item_id VARCHAR(30) NOT NULL, price VARCHAR(30) NOT NULL, date_time TIMESTAMP(100) NOT NULL CURRENT_TIMESTAMP, quantity VARCHAR(100) NOT NULL)";
$set_cart_table = mysql_query($create_cart_table);

 

$string is defined above and there are no database connection warnings etc coming up and I am lost as to how the heck this isn't working? It was working for about an hour when I first made the script but now it is not. Please help?

[xyph]

Echo out mysql_error(). It's probably a duplicate table error

 

Generally, you shouldn't be creating tables on the fly. You should have a single table, with an extra column unique to each 'set' of information.