List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 17 1999 5:39pm
Subject:not getting an insert id
View as plain text  
>>>>> "Phil" == Phil Glatz <phil@stripped> writes:

Phil> A vexing problem: identicalPHP code on two platforms, one retrurns correct 
Phil> insert ID, one doesn't. Mucho appreciation to whomeve can]t point out my 
Phil> stupid error. schema: CREATE TABLE categories ( cat_id int(10) unsigned 
Phil> zerofill NOT NULL DEFAULT '0000000000' auto_increment, cat_name varchar(80) 
Phil> NOT NULL DEFAULT '?', cat_keywords varchar(255), PRIMARY KEY (cat_id) ); 
Phil> PHP:    test:
Phil> h:
Phil> stat:
Phil> id:
Phil> System 1 is Solaris 2.6/PHP 3.012/Apache 1.3.6/mySQL 3.22.23b It returns 
Phil> correct insert id. System 2 is FreeBSD 2.2.2/PHP 3.07/Apache 1.3.4/mySQL 
Phil> 3.22.19b It always return insert id of 3306. 3306? what gives? thanks! 

Phil> ---------------------------------------------------------------------
Phil> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
Phil> posting. To request this thread, e-mail mysql-thread13078@stripped

Phil> To unsubscribe, send a message to the address shown in the
Phil> List-Unsubscribe header of this message. If you cannot see it,
Phil> e-mail mysql-unsubscribe@stripped instead.

Hi!

I would recommend compiling PHP and MySQL on the second system; The
only explanation I can think off is that PHP was compiled with an old
copy of the MySQL include files (that didn't match the used library).

Regards,
Monty
Thread
not getting an insert idPhil Glatz14 Sep
  • Re: not getting an insert idMartin Ramsch14 Sep
  • not getting an insert idMichael Widenius17 Sep