Re: if table not exists

[Steve Buehler <steve@xxxxxxxxx>]

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

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php