Apache Friends Support Forum

// SQL script to create table tproject

$createCoyTable_SQL = "CREATE TABLE dmpm.tProject ( ";
$createCoyTable_SQL .= "ID INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , ";
$createCoyTable_SQL .= "Job_numb VARCHAR( 50 ) NULL, ";
$createCoyTable_SQL .= "Proj_name VARCHAR( 250 ) NOT NULL, ";
$createCoyTable_SQL .= "Proj_init VARCHAR( 50 ) NULL, ";

$createCoyTable_SQL .= "Date_open VARCHAR( 150 ) NULL, ";
$createCoyTable_SQL .= "Clie_name VARCHAR( 150 ) NULL, ";
$createCoyTable_SQL .= "Clie_cont VARCHAR( 150 ) NULL, ";
$createCoyTable_SQL .= "Clie_code VARCHAR( 150 ) NULL, ";
$createCoyTable_SQL .= "Esti_date VARCHAR( 150 ) NULL, ";
$createCoyTable_SQL .= "Crea_date VARCHAR( 50 ) NULL, ";

$createCoyTable_SQL .= "Deli_date VARCHAR( 250 ) NULL, ";
$createCoyTable_SQL .= "Esti_requ-bc VARCHAR( 250 ) NULL, ";
$createCoyTable_SQL .= "Esti_requ_wc VARCHAR( 250 ) NULL, ";
$createCoyTable_SQL .= "Proj_desc VARCHAR( 250 ) NULL, ";
$createCoyTable_SQL .= "Proj_spec VARCHAR( 250 ) NULL, ";

$createCoyTable_SQL .= "Orig_inst VARCHAR( 250 ) NULL, ";
$createCoyTable_SQL .= "Revi_inst VARCHAR( 250 ) NULL, ";
$createCoyTable_SQL .= ") ";

if (mysql_query($createCoyTable_SQL)) {
echo "'Create TABLE tProject' - Successful.<br /><br />";
}
else {
echo "'Create TABLE tproject' - Failed. <br /><br />";
}

mysql_error() is your friend