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..
