Jump to content

Create Table PHP Script


MnSd

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
Link to comment
https://forums.phpfreaks.com/topic/24167-create-table-php-script/
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

Archived

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

×
×
  • Create New...

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.