Posted by Sanders Kaufman on 11/17/06 16:04

casper christensen wrote:
> Well
>
> Using the insert tag, it returns the value"0", any idea why. Obviously
> it doesnt get the last inserted id (tried Last_insert_id.. too)


It may be that the connection was reused by your server.
You have to make sure that the INSERT was the LAST
command on the connection.

Because of this little gotcha, I've had to abandon
AUTO_INCREMENT as a PRMARY KEY altogether,
generating my own PK instead (on MYSQL).

[Back to original message]