Re: [PHP] last inserted record

2001-03-08 Thread Christian Reiniger
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 "tim

Re: [PHP] last inserted record

2001-03-08 Thread Soeren Staun-Pedersen
> 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

Re: [PHP] last inserted record

2001-03-08 Thread Christian Reiniger
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

Re: [PHP] last inserted record

2001-03-07 Thread John Meyer
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? "Christian Reiniger" <[EMAIL PROTECTED]> wrote in message 01030310383101.00589@chrisbig">news:01030310383101.00589@chrisbig... On Saturday 03 March 2001 05:16, y

Re: [PHP] last inserted record

2001-03-03 Thread Christian Reiniger
On Saturday 03 March 2001 05:16, you wrote: > i'm having a little bit of problems with a little mysql table i'm > using. the table has no primary key nor index nor nothing. > > i was wondering if it's possible to select the last inserted record of > a table with this characteristics. Add a prima