Close Window

Mysql command in PHP syntax to drop / create table

$query="DROP TABLE IF EXISTS TblCategory"; 
  mysql_query($query)
  or die( "Unable to drop $TblCategory
$query
" . mysql_error());

$query="CREATE TABLE TblCategory (id int(4) NOT NULL auto_increment,
     KeyCategory varchar(30) NOT NULL default '0',
     PRIMARY KEY  (id)) TYPE=MyISAM";

mysql_query($query)
  or die( "Unable to Build TblCategory
$query
" . mysql_error());

Close Window