Re: Changing Front Page from 'Most Recent'
One thing Wordpress does not provide it is: order by custom field.
That means you would need a custom query post in order to sort the posts by custom field, in this case "price".
Would be something like this:
Code:
<?php
$querystr = "
SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'price'
AND wposts.post_type = 'page'
ORDER BY wpostmeta.meta_value ASC
"; ?>
IMO, I don't think it is a good idea. Creating an worst case scenario here. " 2 months ago you had 50 items costing between $10 and $50. This week you had 30 users adding items costing more than $100. What happens to your front page? it will still be showing all the old items while the new ones will never get to the homepage."
Some users may not like that and some others may set the price in the custom field as $0 and the real price in the description just to appear on the front page.
Just my opinion though.
