RE: [PHP-DB] mysql LIMIT and ORDER BY problem
| From: | Rick Emery | Date: | Wed, 20 Feb 2002 14:38:07 +0000 |
| Subject: | RE: [PHP-DB] mysql LIMIT and ORDER BY problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17086@lists.php.net to get a copy of this message | ||
it works for me. What do your data and table structures look like?
-----Original Message-----
From: Fredrik Wahlberg [mailto:fredrik@wahlberg.se]
Sent: Tuesday, February 19, 2002 4:55 PM
To: php-db@lists.php.net
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