On Thursday 08 March 2001 10:31, you wrote:
> > 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
Which however only works (1) with autoincrement keys and (2) for the last
insert you did using the same mysql connection, i.e. if you do an insert
in foo.php, mysql_insert_id () won't show anything in bar.php
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
Very funny, Scotty! Now beam up my clothes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
