Can anyone tell me why won't this work.

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Can anyone tell me why won't this work.

Postby xjmf » 05. April 2013 16:05

// 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 />";
}
xjmf
 
Posts: 3
Joined: 27. March 2013 16:32
XAMPP Version: 5.6.3
Operating System: XP;Vista;Windows 7

Re: Can anyone tell me why won't this work.

Postby Altrea » 05. April 2013 16:12

mysql_error() is your friend
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6536
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 61 guests