php: mysql_insert_id() issues

inetryconydot

New Member
Can the php function mysql_insert_id() return no result after processing the INSERT query in mysql db?Just to clarify. There was a script performing by cron on the production site. It contained a cycle for generating invoices for users. Each iteration consists of a INSERT db query and the mysql_insert_id() operation going right after the query - to fetch the generated invoice number. A set of iterations were performed without fetching the last inserted number.Can it be caused by high db server load or by some other reasons that are not linked to the problem at the php code site?Any help would be appreciated!
 
Back
Top