it works for me. What do your data and table structures look like? -----Original Message----- From: Fredrik Wahlberg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 4:55 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql LIMIT and ORDER BY problem
I have a strange problem with LIMIT. When I use it like "SELECT * FROM table LIMIT 0, 10" it works fine. When I add a sort and write the query like "SELECT * FROM table ORDER BY col ASC LIMIT 0, 10" I get no results. What am I missing? /Fredrik -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php