On Tue, Jun 2, 2009 at 11:49 AM, HELP! <izoduwa@xxxxxxxxx> wrote:
> Hi,
>
> how do you select the most recent row from sql table if the date are stored
> this format date('Y-m-d H:i:s') e.g (2009-06-02 10:10:30)
>
> i have tried select top 1 from table where id = xx
> any solution
> --
> www.bemycandy.com
>
select top 1 from table where id = xx order by date_field desc
--
Bastien
Cat, the other other white meat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
