creating a new table

[pouncer]

$create_str = "CREATE TABLE $cat (item_id INT not null auto_increment primary key, image_URL text)";
$cre = mysql_query($create_str);

 

is there something wrong with my code, because it just doesn't create the table :s

[chawezul]

Your query is sound and it worked on my system. Perhaps you didn't select a database with mysql_select_db() ?

 

Also you can try to see if $cat gets deleted or set to "" at any point.

[pouncer]

at the top of the page i have

 

require_once("../php_classes/class_login.php");

 

and that class_login has all the connect/select db stuff in there.

 

i checked the $cat value too, it doesn't change :s

 

i am stumped :s

[chawezul]

Make your script print() or echo() your query string out to you, then paste it into PhpMyAdmin or similar and see if it yields any errors or hints.