"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 BY clause. I would suggest reversing the ORDER BY and using LIMIT to take the *first* ten records, ie SELECT * 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