MnSd Posted October 17, 2006 Share Posted October 17, 2006 HiI'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 Connectionmysql_connect("host", "user", "pass") or die(mysql_error());mysql_select_db("test") or die(mysql_error());// Create a MySQL table in the selected databasemysql_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 More sharing options...
tomfmason Posted October 17, 2006 Share Posted October 17, 2006 Your forgot a " and ) at the end of your query.Tom Link to comment https://forums.phpfreaks.com/topic/24167-create-table-php-script/#findComment-109823 Share on other sites More sharing options...
MnSd Posted October 17, 2006 Author Share Posted October 17, 2006 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 Link to comment https://forums.phpfreaks.com/topic/24167-create-table-php-script/#findComment-109826 Share on other sites More sharing options...
tomfmason Posted October 17, 2006 Share Posted October 17, 2006 try replacing the single quotes with back ticks Link to comment https://forums.phpfreaks.com/topic/24167-create-table-php-script/#findComment-109835 Share on other sites More sharing options...
fenway Posted October 17, 2006 Share Posted October 17, 2006 Or dropping the backticks entirely. Link to comment https://forums.phpfreaks.com/topic/24167-create-table-php-script/#findComment-110101 Share on other sites More sharing options...
MnSd Posted October 17, 2006 Author Share Posted October 17, 2006 Thanks Tomfmason n Modproblem has solvedRegards Link to comment https://forums.phpfreaks.com/topic/24167-create-table-php-script/#findComment-110303 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.