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. Link to comment https://forums.phpfreaks.com/topic/39984-solvedsql-syntax-error/ 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. Link to comment https://forums.phpfreaks.com/topic/39984-solvedsql-syntax-error/#findComment-193367 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) Link to comment https://forums.phpfreaks.com/topic/39984-solvedsql-syntax-error/#findComment-193370 Share on other sites More sharing options...
ryandarin Posted February 25, 2007 Author Share Posted February 25, 2007 Yep, I got it, thanks Link to comment https://forums.phpfreaks.com/topic/39984-solvedsql-syntax-error/#findComment-193371 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.