I'm new in php. please help me anyone how to make search for Multiple countries.
I use AZDG dating script. There is only 1 choise. I have changed:
<select name="country" class="input">
<? $p=0;asort($wcr);reset($wcr);
while (list ($p, $val) = each ($wcr)) {
echo '<option value="'.$p.'">'.$val;
}
?>
</select>
To
<select multiple name="country" class="input">
<? $p=0;asort($wcr);reset($wcr);
while (list ($p, $val) = each ($wcr)) {
echo '<option value="'.$p.'">'.$val;
}
?>
</select>
wcr=countries list.
It makes multiple selecting, but in search not works for multiple result. When value=0 it searchs any country, but another value result is only 1 country. I want to search at same time for 2 or more countries; germany, italy,...
Maybe I must change another part?
Can anyone help me?
here is full search page code:
// Important /////////////
$id != "" ? $mid = " id = '".$id."' AND status >= '7'" : $mid = " status >= '7'";
//////////////////////////
!empty($horo) ? $mhoro=" AND horo = '".$horo."'" : $mhoro = "";
!empty($zip) ? $mzip=" AND zip = '".$zip."'" : $mzip = "";
!empty($keywords) ? $mkeywords=" AND (descr LIKE '%".$keywords."%' OR hobby LIKE '%".$keywords."%' OR job LIKE '%".$keywords."%')" : $mkeywords = "";
$magef=" AND birthday <= DATE_SUB(NOW(), INTERVAL ".$agef." YEAR)";
$maget=" AND birthday >= DATE_SUB(NOW(), INTERVAL ".($aget+1)." YEAR)";
!empty($gender) ? $mgender=" AND gender = '".$gender."'" : $mgender = "";
!empty($purpose) ? $mpurpose=" AND purposes = '".$purpose."'" : $mpurpose = "";
!empty($country) ? $mcountry=" AND country = '".$country."'" : $mcountry = "";
!empty($regin) ? $mregin=" AND regdate > DATE_SUB(NOW(), INTERVAL ".$wrgv[$regin]." DAY)" : $mregin = "";
$sql="SELECT * FROM ".C_MYSQL_MEMBERS." WHERE ".$mid.$mhoro.$mzip.$mkeywords.$magef.$maget.$mgender.$mpurpose.$mcountry.$mregin.$msortby." limit ".$from.",".$step;
$tsql = "SELECT count(id) as total FROM ".C_MYSQL_MEMBERS." WHERE ".$mid.$mhoro.$mzip.$mkeywords.$magef.$maget.$mgender.$mpurpose.$mcountry.$mregin;
$result = mysql_query($sql) or die(mysql_error());
$tquery = mysql_query($tsql) or die(mysql_error());
$trows = mysql_fetch_array($tquery);
$count = $trows['total'];
if($count == "0") printm($w[110]);
$str='';$color='';
while ($i = mysql_fetch_array($result)) {
if(($i['pic1'] == '')&&($i['pic2'] == '')&&($i['pic3'] == '')) {$picav = $w[111];$sk=0;} else {$picav = $w[112];$sk=1;}
if((C_SEARCH_PHOTO) && ($sk)) {
$photo=not_empty($i['pic1'],$i['pic2'],$i['pic3']);
$picav='<a href="'.C_URL.'/members/uploads/'.$photo.'" target="_blank"><img src="'.C_URL.'/members/uploads/'.$photo.'" border="'.C_IMG_BRDR.'" width=50></a>';
}
$color = ($color == COLOR4) ? COLOR3 : COLOR4;
$age=mysql2data($i['birthday'],1);
$name = (trim($i['fname']) == '') ? $i['id'] : $i['fname'];
$str.="<Tr bgcolor=".$color." align=center><td><a href=view.php?l=".$l."&id=".$i['id'].">".$name."</a></td><td>".$wg[$i['gender']]." ".$wp[$i['purposes']]."</td><td>".abs($age)."</td><td>".$wcr[$i['country']]."</td><td>".$i['city']."</td><td>".mysql2data($i['editdate'])."</td><td>".mysql2data($i['regdate'])."</td><td>".$picav."</td></tr>";
}
$param='l='.$l.'&a=s&id='.$id.'&horo='.$horo.'&agef='.$agef.'&aget='.$aget.'&gender='.$gender.'&zip='.$zip.'&keywords='.$keywords.'&purpose='.$purpose.'&country='.$country.' in='.$regin.'&sortby='.$sortby;
$colspan=8;
$str.=pages($from,$step,$count,$param,$colspan);
$str.="</table></td></tr></table>";
?>
<br>
<span class=head><?=search_results($from,$step,$count);?></span>
<br><br>
<Table CellSpacing="<?=C_BORDER?>" CellPadding="0" width="<?=C_BWIDTH?>" bgcolor="<?=C_TBCOLOR?>"><Tr><Td>
<Table Border=0 CellSpacing="<?=C_IBORDER?>" CellPadding="<?=C_CELLP?>" width="<?=C_BWIDTH?>" class=mes>
<Tr align="center" bgcolor="<?=COLORH?>"><Td><?=$w[118]?></td>
<Td><?=$w[119]?></td><Td><?=$w[120]?></td><Td><?=$w[121]?></td><Td><?=$w[122]?></td><Td><?=$w[123]?></td><Td><?=$w[124]?></td><Td><?=$w[87]?></td></Tr>
<?=$str;?>
<?
} else {
?>
<form action="<?=filename()?>" method="post">
<input type="hidden" name="l" value="<?=$l?>">
<input type="hidden" name="a" value="s">
<input type="hidden" name="gender" value="1">
<input type="hidden" name="regin" value="0">
<input type="hidden" name="sortby" value="0">
<input type="hidden" name="step" value="15">
<center><span class=head><?=$w[91]?></span>
<Table CellSpacing="<?=C_BORDER?>" CellPadding="0" width="<?=C_WIDTH?>" bgcolor="<?=C_TBCOLOR?>"><Tr><Td>
<Table Border=0 CellSpacing="<?=C_IBORDER?>" CellPadding="<?=C_CELLP?>" width="<?=C_WIDTH?>" class=mes>
<Tr align="<?=C_ALIGN?>" bgcolor="<?=COLOR1?>"><Td>
<?=$w[120]?></td>
<td><select name="agef" class="sinput">
<? for($p=C_AGES;$p<=C_AGEB;$p++){
if($p == C_AGES) echo '<option selected>'.$p;
else echo '<option>'.$p;
}?>
</select> - <select name="aget" class="sinput">
<? for($p=C_AGES;$p<=C_AGEB;$p++){
if($p == C_AGE😎 echo '<option selected>'.$p;
else echo '<option>'.$p;
}?>
</select>
</td></tr>
<Tr align="<?=C_ALIGN?>" bgcolor="<?=COLOR1?>"><Td>
<?=$w[133]?></td>
<td>
<select name="purpose" class="input">
<? $p=0;while(isset($wp[$p])) {echo '<option value="'.$p.'">'.$wp[$p];$p++;}
?>
</select>
</td></tr>
<Tr align="<?=C_ALIGN?>" bgcolor="<?=COLOR1?>"><Td>
<?=$w[121]?></td>
<td>
<select name="country" class="input">
<? $p=0;asort($wcr);reset($wcr);
while (list ($p, $val) = each ($wcr)) {
echo '<option value="'.$p.'">'.$val;
}
?>
</select>
</td></tr>
<Tr align="<?=C_ALIGN?>" bgcolor="<?=COLOR1?>"><Td colspan=2>
<table width=100%><tr><td align=left><a href="advsearch.php?l=<?$l?>" class=desc>[<?=$w[125]?>]</a></td><td align=right><input type="submit" value="<?=$w[91]?>" class=button></td></tr></table>
</td></tr></table></td></tr></table></form>
<? } include_once 'templates/'.C_TEMP.'/footer.php'; ?>
