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-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 to

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 "timestamp". In

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,

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 primary

[PHP] last inserted record

2001-03-02 Thread .:: romina ::.
hello. 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. i've been trying but with no good results. thanks for