Display a Preferred Group as first result

[Marti]

My database has my stuff and competitors items for sale. I have written a PHP search script that allows users to dynamically select what criteria they want to base their search. Results will always be formatted in an ASC order based upon price.

What I want to do is Group these results by vendor and then have my Group always display first? I am using the latest MySQL, PHP4x, and Apache. I've tried a CASE statement but the results were spiradic: I obviously did it wrong and I wasn't sure it would ever work. Currently, I'm thinking about the following:

SELECT FROM idxdownloansfm, fa
WHERE $sqlZ
AND EXISTS (SELECT FROM fa
LEFT JOIN idxdownloadsfm ON fa.LO_NAME=idxdownloadsfm.LO_NAME
WHERE fa.LO_NAME = 'FIRST ADVANTAGE ERA'
ORDER BY LO_NAME;

but I have not tested this and am looking for help. Thanks to all who read!!!!

[devinemke]

i suggest using the UNION syntax. select everything from your group order by price then select everything else ordered first by vendor then by price and return them together using UNION.