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!";

 

  ?>

there is missing ) at the end of the query
shouldn't be like this

PHP Code:

mysql_query("CREATE TABLE food(

 id INT NOT NULL AUTO_INCREMENT,

  PRIMARY KEY(id),

  position VARCHAR(30),

  meal VARCHAR(30))"); 


THANK YOU SO MUCH JOHN!!! IVE BEEN WAITING 2 DAYS FOR THAT lol. so thank you very much . derek