Re: if table not exists

http://dev.mysql.com/doc/mysql/en/create-table.html At 03:29 PM 3/15/2005, John Taylor-Johnston wrote:

How do I get PHP to create a table, if one does not already exist? I have to do something with: $news = mysql_query($sql) or die(print mysql_error()); What can I also add something to $sql? $sql = "if not exists CREATE TABLE demo_assignment1 ... John --------snip-------- $server = "localhost"; $user = "myname"; $pass = "mypass"; $db = "mydb"; $table = "demo_assignment1"; ############################################ ## What do I add here? ############################################ $sql = "CREATE TABLE demo_assignment1 ( StudentNumber varchar(8) NOT NULL default '', Exercise1 varchar(100) NOT NULL default '', Exercise2 varchar(100) NOT NULL default '', TimeStamp timestamp(14) NOT NULL, PRIMARY KEY (TimeStamp) ) TYPE=MyISAM COMMENT='place something here';"; $myconnection = mysql_connect($server,$user,$pass); mysql_select_db($db,$myconnection); ############################################ ## What do I do here? $news = mysql_query($sql) or die(print mysql_error()); ############################################ #if table exists, I will now $sql = "INSERT INTO $table (StudentNumber,Exercise1,Exercise2)

    values ('$StudentNumber','$Exercise1','$Exercise2')";

mysql_select_db($db,$myconnection); mysql_query($sql) or die(print mysql_error()); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php