search query with radio buttons!

v3nt

doing a quick backup html site for an estate agents but having trouble with radio buttons in the search field. if i click on more than one i get no results? how can i get it to search for all or any of the ticked radio buttons?

Many thanks. DAN.

PD. areas1-10 are the radio buttons.

link;
http://www.hughgrover.co.uk/htmlsite/search.html

$query_PD = "SELECT * FROM property WHERE pavailable='1' AND synchDel !='1'
AND paddress1 like\"%$stname%\"
AND ppostcode like\"$area1%\" AND ppostcode like\"$area2%\"
AND ppostcode like\"$area3%\" AND ppostcode like\"$area4%\"
AND ppostcode like\"$area5%\" AND ppostcode like\"$area6%\"
AND ppostcode like\"$area7%\" AND ppostcode like\"$area8%\"
AND ppostcode like\"$area9%\" AND ppostcode like\"$area10%\"

AND pg1=1
AND pprice>$minprice AND pprice<$maxprice
AND pg5>$MinBedrooms AND pg5<$MaxBedrooms

ORDER BY pforsdate DESC";

Weedpacket

It's probably because you're using AND instead of OR - it's not often that a property is going to be in E8 AND N19, is it?

AND paddress1 like\"%$stname%\" AND
(ppostcode like\"$area1%\" OR ppostcode like\"$area2%\"
OR ppostcode like\"$area3%\" OR ppostcode like\"$area4%\"
...etc. )
AND pg1=1

etc.

But I don't think you'll be happy with the results. ppostcode like "%" is not a smart thing to have.

You don't need to put the entire query together at once.

$query_PD = "SELECT * FROM property WHERE pavailable='1' AND synchDel !='1'
AND paddress1 like\"%$stname%\" "; 
$areas = array();
if(isset($area1)) $areas[]="ppostcode like \"$area1\"";
...
$areas = join(' OR ', $areas);
if($areas!='')
{
  $query_PD .= " AND ($areas)";
}
$query_PD .= " AND pg=1....";

(PS: they're checkboxes; radio buttons are different.)

v3nt

thanks for the response.

i tried using OR but it seemed to ignore the other requirements for the query giving me hundreds of reslults. Except for that it worked.

AND pavailable='1' AND synchDel !='1' are very important as they are porperties no longer available but the query now ignores these fields? any ideas?

$query_PD = "SELECT * FROM property WHERE

ppostcode like\"$area1\" OR ppostcode like\"$area2%\" OR ppostcode like\"$area3\" OR ppostcode like\"$area4\"

AND pg1=1
AND pprice>$minprice AND pprice<$maxprice
AND pg5>$MinBedrooms AND pg5<$MaxBedrooms
AND pavailable='1' AND synchDel !='1'
AND paddress1 like\"%$stname%\"

ORDER BY pforsdate DESC";

Weedpacket

The parentheses around the OR'd clauses are required. foo AND bar OR baz is not the same as foo AND (bar OR baz).