From: abdulazeez alugo Date: April 7 2009 2:32pm Subject: RE: PHP-MYSQL Question List-Archive: http://lists.mysql.com/mysql/217018 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_468097bd-09e3-491e-b351-64877747b367_" --_468097bd-09e3-491e-b351-64877747b367_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've done that but it still gives the same error message. =20 Date: Tue=2C 7 Apr 2009 16:25:15 +0200 Subject: Re: PHP-MYSQL Question From: spap13@stripped To: defatigue@stripped CC: mysql@stripped it is not the ENGINE as Eugene mentioned above=2C is that you need to use U= NSIGNED when creating the second table CREATE TABLE table2 ( table2_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT=2C table1_id INT UNSIGNED NOT NULL=2C name VARCHAR(100) NOT NULL=2C school VARCHAR(100) NOT NULL=2C comment TEXT NOT NULL=2C entrydate TIMESTAMP NOT NULL=2C FOREIGN KEY(table1_id) REFERENCES table1(table1_id)) ENGINE =3D INNODB _________________________________________________________________ Show them the way! Add maps and directions to your party invites.=20 http://www.microsoft.com/windows/windowslive/products/events.aspx= --_468097bd-09e3-491e-b351-64877747b367_--