Alright guys, I just solved the problem. I read from somewhere that if you're using a foreign key, it should be the either the primary key in the table or the index so since I already used auto increment on table2_id and I've already made it my Primary key, I just made table1_id the index and it returned successful. So that was the problem all along.
Thanks for your suggestions. Best regards Alugo Abdulazeez. > From: defati...@hotmail.com > To: spa...@googlemail.com > CC: mysql@lists.mysql.com > Subject: RE: PHP-MYSQL Question > Date: Tue, 7 Apr 2009 15:32:25 +0100 > > > > I've done that but it still gives the same error message. > > > > > Date: Tue, 7 Apr 2009 16:25:15 +0200 > Subject: Re: PHP-MYSQL Question > From: spa...@googlemail.com > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > > > it is not the ENGINE as Eugene mentioned above, is that you need to use > UNSIGNED when creating the second table > > > CREATE TABLE table2 ( table2_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, > table1_id INT UNSIGNED 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 > > > > _________________________________________________________________ > Show them the way! Add maps and directions to your party invites. > http://www.microsoft.com/windows/windowslive/products/events.aspx _________________________________________________________________ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx
