simcoweb Posted July 21, 2006 Share Posted July 21, 2006 Simple. Trying to create a table. Looked at this code 'til i'm ready to puke. Compared with other ones i've done that work fine. Perhaps another set of eyes can set me straight. [code]<?php include 'config.php';// Make connect to DB firstmysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());mysql_select_db($dbname) or die("Where is the dang database");// Now we create the tables and rowsmysql_query("CREATE TABLE members(business VARCHAR(255) NOT NULL, name VARCHAR(30) NOT NULL PRIMARY KEY, title VARCHAR(30) NOT NULL, phone VARCHAR(30) NOT NULL, email VARCHAR(30) NOT NULL, url VARCHAR(30) NOT NULL, details VARCHAR(30) NOT NULL, category VARCHAR(30) NOT NULL") or die(mysql_error());echo "Table Was Created Successfully!"; ?>[/code]Error I get:[quote]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 '' at line 9[/quote]Hellllllllllllllllllp meeeeeeeeeeeeeeeeeeeeee....... :P Quote Link to comment Share on other sites More sharing options...
Prismatic Posted July 21, 2006 Share Posted July 21, 2006 [code]<?php include 'config.php';// Make connect to DB firstmysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());mysql_select_db($dbname) or die("Where is the dang database");// Now we create the tables and rowsmysql_query("CREATE TABLE members(business VARCHAR(255) NOT NULL, name VARCHAR(30) NOT NULL PRIMARY KEY, title VARCHAR(30) NOT NULL, phone VARCHAR(30) NOT NULL, email VARCHAR(30) NOT NULL, url VARCHAR(30) NOT NULL, details VARCHAR(30) NOT NULL, category VARCHAR(30) NOT NULL)") or die(mysql_error());echo "Table Was Created Successfully!"; ?>[/code] Quote Link to comment Share on other sites More sharing options...
KittyKate Posted July 21, 2006 Share Posted July 21, 2006 Prismatic beat me to it, but if you can't find the difference....You are missing a closing bracket at the red spot:category VARCHAR(30) NOT NUL[color=red]L)"[/color]) or die(mysql_error()); Quote Link to comment Share on other sites More sharing options...
simcoweb Posted July 21, 2006 Author Share Posted July 21, 2006 Well son-of-a-biscuit-maker. Thanks for being the other set of 'eyes'! ::) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.