Hello
Im trying to get from my database only the data that is within the range typed by the user
for example :

price range :
_________ till ______________

lets say the user typed : 10,000 till 30,000

now in the data base there is JUST the price of the house.

what will be the php query code in this case?

i was trying something like :
the important part is : AND '$preco1'>=preco<='$preco2'

any help ? Thanks a lot

Danny

p.s.
as well i wanted to know if the query in general is ok
will it show the user only the data base entries between the price range ?

i tried also

but still nothing

please use mysqldump (or equivalent) to produce a CREATE TABLE statement along with several INSERT statements that will have data that illustrates your scenario

this will allow us to test your query on your data to investigate why it isn't working

by the way, this is totally wrong --what you want is this instead --

assuming preco is numeric and the preco1/2 is also numeric ie has no punctuation, then you don't need the '

SELECT * FROM _Form_Nr_2
WHERE preco BETWEEN $preco1 AND $preco2;") or die(mysql_error());