At 20:08 -0500 12/14/02, Michael T. Babcock wrote:
>Peter Lovatt wrote:
>
>>mysql_insert_id
>>should do it!
>>
>
>According to documentation somewhere, last insert can sometimes
>return a different value than the most recent insert if the most
>recent insert failed.
Why is this a problem? If the most recent insert failed, you wouldn't
expect to get a reasonable ID value. If you were wanting to get
the value from the previous insert, you should have gotten its ID before
attempting another insert anyway.
>
>What is a better solution?
>
>--
>Michael T. Babcock
>C.T.O., FibreSpeed Ltd.
>http://www.fibrespeed.net/~mbabcock