I have managed to display a list of sold items by seller id when I run this query through phpmyadmin. I am so happy I figured out how to do this.
The thing that is stumping me, is how I can convert the unix time to the actual date and time and when I run the query.
So all the unixtime in the purchase_date field show the proper time and date.
SELECT aa.purchase_date AS purchase_date, aa.auction_id AS auction_number, bb.name AS auction_title, aa.bid_amount AS total
FROM bidsa_winners aa
LEFT JOIN bidsa_auctions bb ON aa.auction_id = bb.auction_id
WHERE from_unixtime( purchase_date ) >= str_to_date( "01/05/2008", "%d/%m/%Y" )
AND seller_id =17 GROUP BY aa.auction_id
