Featured Listing Requirement

Hi All,

Using cms to display accommodation listings, Hotels etc I am looking to add the facility to provide clients with a featured listing option which would ensure that featured listings apeared at the top of the page so in effect the page is divided into two, just seperated by a horizontal line, with any/all featured listings above the horizontal line and standard listings below it, I do however have a couple of criteria whech needs to be met;

1) At present the list is generated randomly which works fine and changes on each refresh which is how we need it so random listings need to remain.

2) If a listing is a featured listing it needs to appear at the top of this list, but we need to cater for any number of featured listings, all of which must appear in the list before a standard listing and above the horizontal line.

3) The featured listings section must also be randomized on each page load so that each refresh gives a different listing order to both the featured and standard sections.

4) As we havent offered a featured listing facility yet we would only want the featured listing section to display if a featured listing existed in the table so hopefully the page would display as normal if no featured listings have been purchased, if a featured listing exists then the section would be added with suitable text headlining the featured listing section.

An acceptable alternative would be to be able to add an animated gif option to display in the listing of any featured account if this would be easier, but again we need to ensure that featured appeared at the top of the list and randomly within other featured listings.

I feel sure this has already been done but need to check to see if it can be done while retaining the random element to both sections as this is important to our clients and our only reason for upgrading from listings manager.

As stated in earlier posts, we have no php coding knowledge but are pretty good at cut and paste so any help would be appreciated.

Thanks in advance