mysql LIMIT and ORDER BY problem
| From: | Fredrik Wahlberg | Date: | Tue, 19 Feb 2002 22:54:47 +0000 |
| Subject: | mysql LIMIT and ORDER BY problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17071@lists.php.net to get a copy of this message | ||
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