جميل
قم باستبدال هذا الجزء
كود PHP:
<?php
if ($country != "all" && $sex == "all") {
$result = mysql_query("SELECT * FROM users where country='$country' order by id desc Limit $safha,$limit");
$cs = "where country='$country'";
}
elseif ($country == "all" && $sex != all) {
$result = mysql_query("SELECT * FROM users where sex='$sex' order by id desc Limit $safha,$limit");
$cs = "where sex='$sex'";
}
elseif ($country == "all" && $sex == "all") {
$result = mysql_query("SELECT * FROM users order by id desc Limit $safha,$limit");
}
else {
$result = mysql_query("SELECT * FROM users where country='$country' and sex='$sex' order by id desc Limit $safha,$limit");
}
بهذا
كود PHP:
$cs = "where 1=1 ";
if ($country != "all"){
$cs .= "AND country = '$country' ";
}
if ($sex != "all"){
$cs .= "AND sex = '$sex' ";
}
$result = mysql_query("select * from users $cs order by id desc limit $safha, $limit");