Create Table problem

[NME]

I am trying to dynamically create a table with a different name everytime. The following code is used, but it never seems to actually create a Table when i look at the database.

[code]$dbhost = '<myhost>';
$dbusername = '<myusername>';
$dbpasswd = '<mypassword>';
$database_name = '<mydatabasename>';

$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd")  
    or die ("Couldn't connect to server.");
$db = mysql_select_db("$database_name", $connection)
    or die("Couldn't select database.");


$sql = mysql_query ( "CREATE TABLE user_" . $userid . " (
        index int(25) NOT NULL auto_increment,
        count int(25) NOT NULL,
        PRIMARY KEY (index)
        )");
                [/code]

Any ideas why nothing is happening?

[poirot]

Change :
PRIMARY KEY (index)
to
PRIMARY KEY (`index`)

It may help ;)

[NME]

Thanks, but it stil doesnt create me a table.

[poirot]

Do this:

mysql_query(QUERY_HERE) or die (mysql_error())

This should help you know what's going on

[NME]

Ok, this is what is says, but i still cant figure it out:

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 'int(25) NOT NULL auto_increment, freinds int(25) NOT NULL,

[poirot]

OK, Try this:

[code]$sql = mysql_query("
CREATE TABLE `user_$userid` (
  `index` INT( 25 ) NOT NULL AUTO_INCREMENT ,
  `count` INT( 25 ) NOT NULL ,
  PRIMARY KEY ( `index` )
);") or die(mysql_error());[/code]


This should work.

[NME]

hmm im still getting an 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 ''Info_User_19' ( 'index' INT( 25 ) NOT NULL AUTO_INCREMENT ,

by the way, thanks so much for all your time poirot.

[NME]

any help would be really appreciate guys

[samshel]

I think the query poirot gave you should work unless and until you mis-interpreted the backt tick "`" to be a single quote.