ryandarin Posted February 25, 2007 Share Posted February 25, 2007 Hi, this is probably a stupid mistake, but can you please help me out. I am running this code <?php require'dbconnect.php'; mysql_select_db("ryandarin", $link); $sql = "CREATE TABLE Game ( Title varchar(15), Genre varchar(15), Publisher varchar(15), Published varchar(15), )"; mysql_query($sql,$link) or die(mysql_error()); echo 'Tables Created Successfully'; mysql_close($link); ?> and getting this error when I try to run it 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 7 What did I do wrong? Thanks, Ryan. Quote Link to comment Share on other sites More sharing options...
Jessica Posted February 25, 2007 Share Posted February 25, 2007 Take out the last , after the table structure. Quote Link to comment Share on other sites More sharing options...
Archadian Posted February 25, 2007 Share Posted February 25, 2007 I believe jesirose is talking about here: Published varchar(15), make it: Published varchar(15) Quote Link to comment Share on other sites More sharing options...
ryandarin Posted February 25, 2007 Author Share Posted February 25, 2007 Yep, I got it, thanks 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.