MySQL SELECT syntax problem?

[spoonernyc]

hello

So I am trying to do

SELECT * FROM photos WHERE section='$section' ORDER BY lineup ASC

and what I am wondering is whether you can pass two constraints on a SELECT statement; namely the WHERE and ORDERBY.

Do I need an AND or a seperate MySQL call?
and if this doesn't work out I can always sort the results just based off of the WHERE query and then use PHP to sort the results by the lineup value. But I am sure that woudl slow things up a bit...

thanks for any help

[sledgeweb]

Use an AND in the WHERE, and a comma in the ORDER BY

SELECT * FROM table_name WHERE field = $variable AND field2 = $variable2 AND field3 = $variable3 ORDER BY field1 ASC, field2 DESC

-S