Or you could retrieve that information prior to inserting the login information, say, as soon as they type in their login name, store that, then present it.
From: Jason Davidson <[EMAIL PROTECTED]> To: Harlequin <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [PHP] Retrieve The Last Record in a Table Date: Tue, 27 Jul 2004 08:17:19 -0700
You could LIMIT 2, using the order on a column, the first record would be last, the second would be second last. Kinda dirty way to do it, however, off hand, cant think of an alternative, ill post it if i do think of one though.
Jason
On Tue, 27 Jul 2004 09:59:21 +0100, Harlequin
<[EMAIL PROTECTED]> wrote:
> 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" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>
>
> > 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
> > <[EMAIL PROTECTED]> 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
> > >
> > >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
