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 
            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.


Reply via email to