[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/)

Re: [PHP-DB] LIMIT in MS SQL

Example: SELECT TOP 2 * FROM Table Fredrik Wahlberg wrote: Is there any equivalent to MySQL's ?LIMIT x,y? in Microsoft SQL-Server? /Fredrik -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL