Re: last inserted record
| From: | Soeren Staun-Pedersen | Date: | Thu, 08 Mar 2001 09:31:57 +0000 |
| Subject: | Re: last inserted record | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-43012@lists.php.net to get a copy of this message | ||
> On Thursday 08 March 2001 06:42, you wrote:
> > Assuming that you do have a primary key, how can you grab the last
> > record you inserted? Can you use @@IDENTITY, or something like that?
>
> For that I'd add another field - type "timestamp".
> In MySQL, timestamp fields are automatically set to NOW() on each insert
> and update *if* they are not set to something else in it (the insert or
> update)
I would prefer using mysql_insert_id() if possible.
http://www.php.net/manual/en/function.mysql-insert-id.php
Regards,
Søren