[Resolved] An "Order by" question

[Dolemite50]

Hi,
I have a site that allows people to upload mp3's and choose a primary and a secondary genre from a dropdown. It is then entered into a mysql db with columns for genre and genre2.

I want to be able to search for songs by genre, and have the result show up if it finds it in either column. I use this:

WHERE genre = '$genre' OR genre2 = '$genre'

What I would like to do is sort the results so that it shows all of the entries that have the query genre in the primary field and THEN list all of the entries that have the genre query in the 2nd category.

I cant quite figure out the ORDER on this one.

Thanks for any help.

[LordShryku]

There's probably an easier solution, but I'm still on my first cup of coffee, and the first thing that comes to mind is a union query.

   (SELECT field 
      FROM table 
     WHERE genre = '$genre'
  ORDER BY field)
UNION
   (SELECT field 
      FROM table 
     WHERE genre2 = '$genre'
  ORDER BY field)

[Dolemite50]

That worked great, thanks a lot. 🙂