Order By

BEFOR

Is it possible to do an ORDER BY on a column that is flagged ( contains "1") to show this row value first, such as for a drop menu, then the remainder of the column values on ASC or DESC on another column? note: there is only a single "1" for any user, all other rows have not other value in this column

How might this look?

style.primary (contains flag)

then ASC or DESC on style.id

bretticus

Well, certainly (if I understand you correctly)

SELECT * FROM Table ORDER BY Flagged DESC, Name

If Flagged has a value of 1 as opposed to a value of 0, that column will show up first.

BEFOR

bretticus, thank you,

This does ORDER BY Flagged bringing it up first
But Name is not being ordered.

Which I think is due to the joins in the " Color" and "Style" table with a main "Members" table.

'Color' table
CID | ColorHex

'Style' table
styleID | fk_MemID | Flagged | Name

'Member' table
MemID

Would SELECT MAX help ORDER BY on styleID ?

LEFT JOIN Color on Color.CID=Style.Name
WHERE Style.fk_MemID=Member.MemID
ORDER BY Style.Flagged DESC, Style.Name