[SOLVED] error in my code- creating a table

[silverglade]

hi, im creating a "food" table and the browser is giving me an error when i run it, any help greatly appreciated. thank you. note that i put private, user, and pass, where my private info went. derek

 

here is the code

 

<?php

// Make a MySQL Connection

  mysql_connect("private", "user", "pass") or die(mysql_error());

  mysql_select_db("derek_test3") or die(mysql_error());



  // Create a MySQL table in the selected database

  mysql_query("CREATE TABLE food(

id INT NOT NULL AUTO_INCREMENT,

  PRIMARY KEY(id),

  position VARCHAR(30),

  meal VARCHAR(30)")

  or die(mysql_error());


  echo "Table Created!";



  ?>

[angelcool]

You are missing to put a closing parenthesis at the end of the query.

[silverglade]

thanks. i dont see where i put it, it looks like i closed it already? sorry. can you show me where to put the closing parenthesis please? derek

[silverglade]

i found out where to put it, took me a while LOL>

 

 

meal VARCHAR(30))")

 

thank you for the help! derek