November 30th, 1999, 09:36 AM
I've a problem. I hope U can help me.
I'll mak a Select on a TABLE and I'll order the rows and I'll limit the output.
But I can't make ORDER BY and LIMIT x,y in one string.
Here an example:
SELECT id, name from TABLE ORDER BY id LIMIT 0, 10
But this string dosn't go...
I hope U can help me...
November 30th, 1999, 10:24 AM
There is nothing wrong with that query. What error is it giving you when you use it? Are you interfacing with mysql on the command line or thru a script?
December 1st, 1999, 03:30 AM
I've answer myself :P
Sorry I've write the String correct here but not in the PHP source.
I've write here:
... ORDER BY id LIMIT 0, 2;
and in my script:
... LIMIT 0, 2 ORDER BY id;
It's very embarrassingly for me.
But thx for the fast reply.