Search Function please please help

[eukhost]

Hello,

I have a search script for a mysql table but need to have it so it displays the price by minium price and max price

e.g. min price = 12
max price = 100

I need it so it displays the tables results between these prices can anyone one please help?

Cheers

[beckstei]

select price from price_table where price < 100 and price >12
order by price