RE: PHP-MYSQL Question

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: evgeniy@xxxxxxxx
> To: defatigue@xxxxxxxxxxx
> CC: mysql@xxxxxxxxxxxxxxx
> 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=defatigue@xxxxxxxxxxx
> 

_________________________________________________________________
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