Complex Query

very complex...for me...

[omoutop]

Hi to all!
i have the following query:
$query3 = "select * from Users join Reviews on Users.ID = Reviews.User where Location='$LocationUp' and Flag = 'A' limit $offset,$limit";
$result3 = mysql_query($query3);
which joins 2 tables and works perfectly....however...I would like to insert another paramater which orders Reviews by id...something like that:
$query3 = "select * from Users join Reviews on Users.ID = Reviews.User where Location='$LocationUp' and Flag = 'A' limit $offset,$limit order by Reviews.ID";
$result3 = mysql_query($query3);

which is not working at all...
Any ideas?

[omoutop]

$query3 = "select * from Users join Reviews on Users.ID = Reviews.User where Location='$LocationUp' and Flag = 'A' order by Reviews.ID desc limit $offset,$limit";
$result3 = mysql_query($query3);

SOLVED