Jump to content

Archived

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

MnSd

Create Table PHP Script

Recommended Posts

Hi
I'm trying to create a table using php script, but keep getting this error;
[code]Parse error: parse error, unexpected T_STRING in  c:\...  on line 17[/code]

Here is php code;
[code]
<?php
// Make a MySQL Connection
mysql_connect("host", "user", "pass") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

// Create a MySQL table in the selected database
mysql_query("CREATE TABLE 'example' (
  'id' varchar(11) NOT NULL,
  'total_votes' int(11) NOT NULL default '0',
  'total_value' int(11) NOT NULL default '0',
  'used_ips' longtext,
  PRIMARY KEY  ('id')
) TYPE=MyISAM AUTO_INCREMENT=3 ;

or die(mysql_error()); 

echo "Table Created!";

?>
[/code]

Please help me regarding this, I'm novice user corect code or detail help will be appreciated.

Regards

Share this post


Link to post
Share on other sites
Thanks for your quick reply! :)

after correction of  " and )  I got this error:
[code]
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 '
'example' ( 'id' varchar(11) NOT NULL, 'total_votes' int(1
[/code]

Please help again.

Regards

Share this post


Link to post
Share on other sites
Or dropping the backticks entirely.

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.