Yeah I used the mysql_error and it returned Can't create table '.\website\table2.frm' (errno: 150). So what does that say?
> Date: Tue, 7 Apr 2009 17:38:59 +0400 > From: evge...@kosov.su > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: PHP-MYSQL Question > > Perhaps you don't have permissions to create tables? > > It would have been much clearer if your script was like this: > > $result=mysql_query($your_create_table_statement); > if($result){ print"Successful";} > else {print "Unsuccessful: ".mysql_error()} > > > abdulazeez alugo wrote: > > 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. > > > > _________________________________________________________________ > > More than messages–check out the rest of the Windows Live™. > > http://www.microsoft.com/windows/windowslive/ > > > -- > С уважением, > Евгений Косов > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=defati...@hotmail.com > _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us