RE: [PHP-DB] getting data back when inserting
| From: | Stefan | Date: | Wed, 01 Dec 2004 16:28:24 +0000 |
| Subject: | RE: [PHP-DB] getting data back when inserting | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37508@lists.php.net to get a copy of this message | ||
You should easily use
mysql_insert_id();
otherwise you could use something like:
SELECT max(id) FROM ...
But I think the first command is what you're looking for.
Stefan
> -----Ursprüngliche Nachricht-----
> Von: Aaron Todd [mailto:aaloki88@hotmail.com]
> Gesendet: Mittwoch, 1. Dezember 2004 17:01
> An: php-db@lists.php.net
> 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 (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php