Thanks a bunch...thats exactly what I was looking for.


"Stefan" <[EMAIL PROTECTED]> wrote in message 
You should easily use


otherwise you could use something like:

SELECT max(id) FROM ...

But I think the first command is what you're looking for.


> -----Ursprüngliche Nachricht-----
> Von: Aaron Todd [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 1. Dezember 2004 17:01
> Betreff: [PHP-DB] getting data back when inserting
> I was wondering if somone might be able to suggest a command to me...I am
> inserting data into a MySQL database that has an auto-incrementing primary
> field.  When I insert the data I would like to somehow get the value of
> the
> auto-incrementing primary field.  I thought I could just run a SELECT
> statement on some of the data that I am inserting, but the problem is that
> it could have a duplicate already in the database.
> Anyone know of a command or something to point me in the direction I am
> looking to go?
> Thanks,
> Aaron
> --
> PHP Database Mailing List (
> To unsubscribe, visit: 

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to