[PHP] Re: create if table not exists

[John Taylor-Johnston]

I used phpmyadmin to help generate some code. When I add:

IF NOT EXISTS `mhinse_counter` it mysql_errors that the error is around:

"IF  NOT  EXISTS  `mhinse_counter` CREATE  TABLE  `mhinse_counter` ( "

Can anyone see clear here?


$server = "localhost";
$user = "user1";
$pass = "******";
$db="jtjohnston";
$table="mhinse_counter";


$query = 'IF NOT EXISTS `mhinse_counter`
CREATE TABLE `mhinse_counter` ( `id` int( 10 ) NOT NULL AUTO_INCREMENT ,'
         . ' `IPAddress` varchar( 100 ) NOT NULL default \'\','
         . ' `RemoteHost` varchar( 100 ) NOT NULL default \'\','
         . ' `Language` text NOT NULL ,'
         . ' `StampDate` date NOT NULL default \'0000-00-00\','
         . ' `StampTime` time NOT NULL default \'00:00:00\','
         . ' `TimeStamp` timestamp( 14 ) NOT NULL ,'
         . ' PRIMARY KEY ( `id` ) ) TYPE = MYISAM AUTO_INCREMENT =1';

$myconnection = mysql_connect($server,$user,$pass);
mysql_select_db($db,$myconnection);
mysql_query($query) or die(print mysql_error());



> Tim Van Wassenhove wrote:
> > How can I check if a table exists in a mysql db.
> $query = 'IF NOT EXISTS table CREATE TABLE table (......)';
> mysql_query($query);

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