Creating tables, if no errors display X message.. help!

Original - php Code <? //DO NOT EDIT BELOW THIS LINE!!! include_once("db_connect.php"); $create['rtable']=" CREATE TABLE reviews ( reviewID INT(4) NOT NULL AUTO_INCREMENT, reviewmenut VARCHAR(255) NOT NULL, review TEXT , reviewtitle VARCHAR(250) , PRIMARY KEY (reviewID), KEY contenttitle (reviewtitle) ) "; $create['ptable']=" CREATE TABLE previews ( previewID INT(4) NOT NULL AUTO_INCREMENT, previewmenut VARCHAR(255) NOT NULL, preview TEXT , previewtitle VARCHAR(250) , PRIMARY KEY (previewID), KEY contenttitle (previewtitle) ) "; $create['atable']=" CREATE TABLE previews ( articleID INT(4) NOT NULL AUTO_INCREMENT, articlemenut VARCHAR(255) NOT NULL, article TEXT , articletitle VARCHAR(250) , PRIMARY KEY (articleID), KEY contenttitle (articletitle) ) "; $create['itable']=" CREATE TABLE previews ( iID INT(4) NOT NULL AUTO_INCREMENT, imenut VARCHAR(255) NOT NULL, i TEXT , ititle VARCHAR(250) , PRIMARY KEY (iID), KEY contenttitle (ititle) ) "; //note the last three CREATE statements //use the same table name... //you need to change that. foreach($create as $k=>$v){ if(!mysql_query($v)){ echo "<h3>Error creating table: $k</h3>"; }else{ echo "<h3>Table: $k created successfully!</h3>"; } } //to make this work even better, make the //key values for the array the actual table //name you are creating. ?>

 
<?
 
//DO NOT EDIT BELOW THIS LINE!!!
 
include_once("db_connect.php");
 
$create['rtable']="
CREATE TABLE reviews ( 
  reviewID    INT(4) NOT NULL AUTO_INCREMENT, 
  reviewmenut VARCHAR(255) NOT NULL, 
  review      TEXT , 
  reviewtitle VARCHAR(250) , 
PRIMARY KEY (reviewID), 
KEY contenttitle (reviewtitle) 
)
";
 
$create['ptable']="
CREATE TABLE previews ( 
  previewID    INT(4) NOT NULL AUTO_INCREMENT, 
  previewmenut VARCHAR(255) NOT NULL, 
  preview      TEXT , 
  previewtitle VARCHAR(250) , 
PRIMARY KEY (previewID), 
KEY contenttitle (previewtitle) 
)
";
 
$create['atable']="
CREATE TABLE previews ( 
  articleID    INT(4) NOT NULL AUTO_INCREMENT, 
  articlemenut VARCHAR(255) NOT NULL, 
  article      TEXT , 
  articletitle VARCHAR(250) , 
PRIMARY KEY (articleID), 
KEY contenttitle (articletitle) 
)
";
 
$create['itable']="
CREATE TABLE previews ( 
  iID    INT(4) NOT NULL AUTO_INCREMENT, 
  imenut VARCHAR(255) NOT NULL, 
  i      TEXT , 
  ititle VARCHAR(250) , 
PRIMARY KEY (iID), 
KEY contenttitle (ititle) 
)
";
//note the last three CREATE statements
//use the same table name...
//you need to change that.
 
foreach($create as $k=>$v){
  if(!mysql_query($v)){
    echo "<h3>Error creating table: $k</h3>";
  }else{
    echo "<h3>Table: $k created successfully!</h3>";
  }
}
//to make this work even better, make the 
//key values for the array the actual table
//name you are creating.
?>