Hi, I have been using the ORDER By clause in one of my sql queries and it works fine; however when I combine it with a LIMIT it still order's the results by it doesn't do it the way its supposed to, for example:-
Order By clause without Limit returns:- A B C C C C C C M N T W Order By clause with Limit returns:- C C C C C C M N T W Is there any way to fix this, so that the results with the limit comes out starting with the A and then moves on to the next pages? Also, can I add a count(*) in my sql statement to get the total number of records even though I would be using Limit? I tried something along the lines of:- SELECT *, COUNT(*) from table where column like keyword order by title desc limit 0,10; and that dint work, so any ideas? Thanks.. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
