List:General Discussion« Previous MessageNext Message »
From:abdulazeez alugo Date:April 7 2009 2:32pm
Subject:RE: PHP-MYSQL Question
View as plain text  

 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: spap13@stripped
To: defatigue@stripped
CC: mysql@stripped


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
Thread
PHP-MYSQL Questionabdulazeez alugo7 Apr
  • Re: PHP-MYSQL QuestionEugene Kosov7 Apr
    • RE: PHP-MYSQL Questionabdulazeez alugo7 Apr
      • Re: PHP-MYSQL QuestionEugene Kosov7 Apr
        • RE: PHP-MYSQL Questionabdulazeez alugo7 Apr
          • Re: PHP-MYSQL QuestionEugene Kosov7 Apr
            • RE: PHP-MYSQL Questionabdulazeez alugo7 Apr
              • Re: PHP-MYSQL QuestionSpiros Papadopoulos7 Apr
                • RE: PHP-MYSQL Questionabdulazeez alugo7 Apr
                  • RE: PHP-MYSQL Questionabdulazeez alugo7 Apr