This isn't PHP but mysql question.

You didn't mention that the table itslef is created or not. If not, then it is probably a mysql error,
maybe your installation of mysql doesn't support INNODB.


----- Original Message ----- From: "abdulazeez alugo" <>
To: <>
Sent: Tuesday, April 07, 2009 3:05 PM
Subject: [PHP] PHP-MYSQL Question

Hi guys,

Please can anyone tell me what I'm doing wrong with the code below? It keep returning unsuccessful.

$result=mysql_query("CREATE TABLE table2(table2_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
           table1_id INT NOT NULL,
            name VARCHAR(100) NOT NULL,
           school VARCHAR(100) NOT NULL,
           comment TEXT NOT NULL,
           entrydate TIMESTAMP NOT NULL,
           FOREIGN KEY(table1_id) REFERENCES table1(table1_id))
           ENGINE = INNODB" );

if($result){ print"Successful";}
else {print "Unsuccessful";}

Thanks in advance. Cheers.

Alugo Abdulazeez.

Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to