Click to See Complete Forum and Search --> : Search Function


dag78
04-30-2008, 06:42 AM
Does any body have any idea how to rectify this function, it works on the all part but not when i select any or both of 2 options

function search_clubsclubs(){
$returnstr='';
$where='';
$query = "select * from clubauth
left outer join area on area.areaid=clubauth.areaid
left outer join breed on breed.breedid=clubauth.breedid
where directory = 1";

if(($_POST['area1']!='All')){
$where=$where.neeedsAndclubs($where).' area.areaid='.$_POST['area1'];
}
if(($_POST['breed1']!='All')){
$where=$where.neeedsAndclubs($where).' breed.breedid='.$_POST['breed1'];
}

if($where!=''){
$query=$query.' where '.$where;
}

$result = @mysql_query($query);
$returnstr= $returnstr.'<table width="558" border="0">
<tr>
<td><input type="hidden" name="clubid" value="'.$clubss['clubid'].'" /></td>
</tr>
<tr>
<td><div><b>Club</b></div></td>
<td><div><b>Breed</b></div></td>
<td><div><b>Town/City</b></div></td>
</tr>';
while($clubss=mysql_fetch_array($result))
{
$returnstr= $returnstr.'<tr>
<td><div><a href="clubsearchdisplay.php?clubid='.$clubss['clubid'].'" class="link">'.$clubss['cbname'].'</a></div></td>
<td><div>'.$clubss['breed'].'</div></td>
<td><div>'.$clubss['city'].'</div></td>
<td></td>
</tr>';
}
$returnstr=$returnstr.'</table>';
return $returnstr;
}