Jump to content

Archived

This topic is now archived and is closed to further replies.

NME

Create Table problem

Recommended Posts

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?

Share this post


Link to post
Share on other sites
Change :
PRIMARY KEY (index)
to
PRIMARY KEY (`index`)

It may help ;)

Share this post


Link to post
Share on other sites
Thanks, but it stil doesnt create me a table.

Share this post


Link to post
Share on other sites
Do this:

mysql_query(QUERY_HERE) or die (mysql_error())

This should help you know what's going on

Share this post


Link to post
Share on other sites
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,

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
any help would be really appreciate guys

Share this post


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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.