Tiny searching problem....please help!

pangea Guest

Messages:: 557

Likes Received:: 13

Best Answers:: 0

Trophy Points:: 0

#1

Hi,

I have this code (which I know has the wrong use of the operator BETWEEN)

<?
$SHQuery = "select * from add_property where ";
if($_REQUEST[status]!=""){
$SHQuery.= "status like '%$_REQUEST[status]%' and ";
}

if($_REQUEST[city]!=""){
$SHQuery.= "city like '%$_REQUEST[city]%' and ";
}

if($_REQUEST[state]!=""){
$SHQuery.= "state like '%$_REQUEST[state]%' and ";
}

if($_REQUEST[country]!=""){
$SHQuery.= "country like '%$_REQUEST[country]%' and ";
}

if($_REQUEST[bedrooms]!=""){
$SHQuery.= "bedrooms between '%$_REQUEST[bedrooms]%' and ";
}

$SHQuery = substr($SHQuery, 0, -4) ;

//echo $SHQuery;die();

$SHResult= mysql_query($SHQuery) or die(mysql_error());
if(mysql_num_rows($SHResult)>0){
?>
Click to expand...

It is the 'filtering' of the MySQL data based on a search form.

Please could someone let me know of how to use greater than/less than and/or BETWEEN in this case for the number of bedrooms. If I were to use BETWEEN, I would need to specify a high value so no-one would search above it.

Thanks,

Paul