NYCPHP Meetup

NYPHP.org

[nycphp-talk] Correction: Bizarro Bug trying to insert after using mysql_insert_id

Kristina Anderson ka at kacomputerconsulting.com
Tue Apr 1 23:00:33 EDT 2008


I'm pulling out the ID of the previously inserted row and then 
inserting that as a lookup value in a duplicate row (two rows one for 
edit mode one for published mode).  

Various other places in the app this works fine and there really isn't 
any reason this should be happening.

The query runs fine if I do it from within phpMyAdmin -- but from the 
PHP page the query does not error out but the value in the lookup field 
remains the default value (I've tried both an integer field with 
default value of 0 and a varchar field with default NULL, and in both 
cases the lookup id value will not save to the database).

Anyone ever heard of this happenning before?  I've examined the working 
code in other parts of this app and the related db tables and cannot 
see why this is occurring.

Thanks in advance for any help!
-------------------
Kristina Anderson




More information about the talk mailing list