order by and limit x,y question

lo all

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

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

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?

ups

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.