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
> An: [EMAIL PROTECTED]
> 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
> 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?
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php