"Crosswalkcentral" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
I would suggest reversing the ORDER BY and
using LIMIT to take the *first* ten records, ie
ORDER BY mydate DESC
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php