Why not change the select around (and simplify it) to something like:

select * from prices where product_id=1 order by price_date desc limit 1

__________________
Dynamic Software Development
www.activeminds.ca