[PHP] PHP-MYSQL Question

[abdulazeez alugo]

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.

http://www.microsoft.com/windows/windowslive/products/photos.aspx