Re-order results in showlistings.tpl?

[sunshinemike]

Hi

At the moment showlistings.tpl shows my listings with 'featured' first, and then the remaining listings in order they were added.

If possible I would like my listings to be ordered with

featured listings first
and then Product->listing package one (my most expense which shows photographs and links to customer website),
then Product->listing package two (my next most expensive package showing photogrpahs)
then Product->listing package three (text only ads)

I see in the database structure that the package used to purchase the listing is not stored - just a field for 'featured' (Y/N).

Is there any way I can order my listings in order of the 'package price' or 'package Id' (pId) ??

Am I right in assuming I would need to add a field to class_listings and pass the contents of the pPrice field in class_products to it when an order is placed? That way I could sort on the new field when showing listings?

Am I on the right track? can it be done?

Many thanks

Mike

[Eric Barnes]

Mike,

It could be done and this information is stored in the orders table. So I would probably recommend creating a join query to get this information out. Not very easy since that same query is very complex. Check Listings->getAllListings()