Below works but when an item sells and I update it to "sold" in my DB table, I would like to:
(a) include sold items below current items
(b) sold items to be listed in "date of sale" DESC order
$items = mysql_query ("SELECT * FROM tablename WHERE status='current' AND category1='apples' OR
category2='oranges' ORDER BY prod_number DESC") or die(mysql_error());
//extract every item
while($item = mysql_fetch_array($items))
Any help would be appreciated.