Code: Select all
,Code: Select all
and [syntax="..."] tags [u]where appropriate[/u] when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
I the following query built:
[syntax="sql"]SELECT horse_id, horse_name, horse_breed, horse_registered, horse_sex, horse_color, horse_foaldate, horse_city, horse_state, horse_price FROM HORSE_ADS WHERE horse_state = 'MN' ORDER BY RAND()I want to give priority (top of results) to featured ads, second tier priority to photo ads, and want to place at the bottom free advertisements.
How can I affect the order the results are put in and at the same time randomly order them within their group?.
1) List randomly ordered Featured ads
2) List randomly ordered Photo ads
3) List randomly ordered Free ads[/syntax]
feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags [u]where appropriate[/u] when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]