"Crosswalkcentral" <[EMAIL PROTECTED]> wrote in message
> How can i obtain the last 10 entries that are in mydatabase that have a
> certain colum set to 1?

SQL does not guarantee to return your records
in any specific order unless you use an ORDER
BY clause.

I would suggest reversing the ORDER BY and
using LIMIT to take the *first* ten records, ie

    FROM mytable
    WHERE mycolumn=1
    ORDER BY mydate DESC
    LIMIT 10

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to