Mysql - Order by something

[emcb_php]

Hi,

I know how to order mysql results from the cli (command line interface) but i dont know how to sql a formatted result. What i use is:

SELECT * FROM my_table ORDER BY some_record;

Could someone tell me how i do this in w3c-sql format.

Cheers,

Elfyn