This script:
Code:
SELECT 
		plan.*, trkg.curwipprice_online, trkg.addr 
	FROM 
		plan 
	LEFT 
    JOIN	
		trkg 
	ON 
		plan.cliorder = trkg.cliorder 
	AND trkg.addr = '$addr_clear'	
	WHERE 	
		(TIMESTAMP(NOW()) BETWEEN TIMESTAMP(plan.begin) AND TIMESTAMP(plan.end) )
	ORDER BY ((1-(trkg.curwipprice_online/plan.edprice))*100) DESC
Produces this output:

Item Name.............Price
USS Constitution ........1.75
USS Constitution ........7.55
Peterbilt 353 ........94.92
Wonder Woman........1.65
Wonder Woman........14.22
H.M.S. Beagle ........31
H.M.S. Beagle ........33.77

How do I eliminate the dupes and keep the item_names with the lowest price with SQL or do I need to do that with PHP?