Re: Retrieve The Last Record in a Table

Thanks for that Jason Any suggestions on how I would retrieve the next to last entry...? The last time prior to this session that the user logged in...? -- ----------------------------- Michael Mason Arras People www.arraspeople.co.uk ----------------------------- "Jason Davidson" <jason.davidson@gmail.com> wrote in message news:6c925ae2040726112334d593c0@mail.gmail.com... > as mentioned already, use a column in the table to order the query and > then use LIMIT to only to return one record. Best columns to use would > be an auto_increment or a datetime field type. > > Jason > > On Mon, 26 Jul 2004 18:27:25 +0100, Harlequin > <michael.mason@arraspeople.co.uk> wrote: > > > > > > I would like to retrieve the last entry in a login table and present that to > > a user so they can verify the date we have when they last logged in. > > > > Is this possible...? > > > > -- > > ----------------------------- > > Michael Mason > > Arras People > > www.arraspeople.co.uk > > ----------------------------- > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > >