Re: Mysql Error

[Barry Galbraith]

Drop and create the table in two goes.

//create "title" table 
$title = "DROP TABLE IF EXISTS title";
$results = mysql_query($title) 
or die (mysql_error()); 


$title="CREATE TABLE title ( 
title_id int(20) NOT NULL auto_increment, 
title_name varchar(255)NOT NULL, 
title_serial tinyint(2)NOT NULL default 0, 
title_edition int(4) NOT NULL default 0, 
PRIMARY KEY (title_id), 
KEY title_serial (title_serial,title_edition) 
))"; 
$results = mysql_query($title) 
or die (mysql_error());

Good luck,
Barry.