$query = "select * from TABLE where COLUMN = 'THIS' and 'THAT' order by SOMETHING, ANOTHERTHING ASC";
can you do this?
How do you select two lines from a column with different attributes?
There is absolutely no problem. Just remember that a single column can't be equal to two different things. Perhaps you meant ".. where column=something OR column=anothertning". The order by clause is correct and shpuld work everywhere.