Re: Retrieve The Last Record in a Table
| From: | Jason Davidson | Date: | Mon, 26 Jul 2004 18:23:19 +0000 |
| Subject: | Re: Retrieve The Last Record in a Table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-191903@lists.php.net to get a copy of this message | ||
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
>
>