[SOLVED] PHP if statement

[le007]

$sql = "SELECT * FROM `cheap_tabl` WHERE `property_type` like '$prop_type' and `area` like '$county' and `town_city` like '$town' and `price` > ($minprice + 1) and `price` < ($maxprice + 1) and `bedrooms` > ($minbeds - 1) and `bedrooms` < ($maxbeds + 1) ORDER BY cheap_id DESC LIMIT $from, $max_results";
$sirsql = mysql_query($sql) or die(mysql_error());

 

I'm playing around with this to just show results where price is 50 `price` like '50' isn't working?

[trq]

Firstly, this has nothing to do with a php if statment. In fact, it has little to do with php, its more an sql question. Don't use LIKE unless you need to.

 

SELECT * FROM tbl WHERE price = 50;

[le007]

Ok, thanks