Minimum and maximum prices

I have two tables... 'product' and 'product_prices'.

The 'product' table simply holds basic information about various products and the 'product_prices' holds a number of prices for each product which have been extracted from various retailers.

I want to find out the lowest and highest price for a particular product and preferably do it in just the one query.

I have this...

SELECT
	MAX(price) AS PRICEhigh,
	MIN(price) AS PRICElow
FROM
	product_price
WHERE
	product_price.productID = " . $aProduct[ID] . "

Code (markup):

After using print_r() in PHP all it seems to do is return the two highest prices.

If you have any ideas on how to fix, it would help greatly

Thanks

 

Problem solved - had the wrong data type in my table