Dude.  If you have multiple records with an ID of 56, then either a) we
don't agree on the definition of an ID or b) you've screwed something up.

The easiest way is to set up the column as an auto-increment.  That way,
you never have to worry about this scenario (or race conditions).

--Ben Doom

[EMAIL PROTECTED] wrote:

> whats the "proper" way to get the last inserted id out, u cant use max(id)
> i dont believe. however say the last number was 56, there could be 20 or
> so 56's i just need to have the next one insert as 57.
> i know i can so some things with the query but it behaves odd sometimes
>
> ty
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to