Er Sahaj Arora Er Sahaj Arora - 4 months ago 9
MySQL Question

Search query for 2 text box

My sql query is

$sel = "select * from search where name like '$search%' and price >'$price' ";


but i didn't get the correct result,

there are some problem in price
Database

Answer

Try to put the price without '...' just like a numeric value not like a varchar.

$sel = "select * from search where name like '$search%' and price >". $price;
Comments