ORDER by query problem 1

[dle46163]

Hi!

In a PHP script I have this query:

$query = "SELECT name, description FROM mytable
WHERE file_id='$file_id'
AND sector='1'
OR file_id='$file_id'
AND sector='2'
ORDER by name";

I can't get the sort to work and am pretty sure I've got the syntax wrong for the "ORDER by" part.. any thoughts would be great!

 

[guelphdad]

your order by is fine, it is your mix of ORs and ANDs that is the problem.

What you most likely are after is this:

 $query = "SELECT name, description FROM mytable
  WHERE 
(file_id='$file_id'
  AND sector='1')
  OR 
(file_id='$file_id'
  AND sector='2')
  ORDER by name";

 

[r937]

actually, guelphdad, your parentheses don't change a thing

dle46163, the ORDER BY looks okay to me

what order did you want the results in?


p.s. you can also write the WHERE clause as ...

WHERE file_id = '$file_id' AND sector IN ( 1,2 )




r937.com | rudy.ca