error in syntax

[mike08]

could someone please tell me where im going wrong

$query = "SELECT username, email, comments FROM guestbook ORDER_BY user_id";

this is the error i receive

ERROR, ERROR!You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user_id' at line 1

[AstroTeg]

You have "ORDER_BY" and it should be "ORDER BY" (no underline between ORDER and BY).

[mike08]

Thanks buddy ive been puzzled over that for ages - silly me

cheers