php - 多个AND条件在选择查询PHP myadmin MYSQL中一个条件不起作用

Question

    $_SESSION['post'] = array($_SESSION['gender'],$_SESSION['star'],$_SESSION['caste'],$_SESSION['marital'],$_SESSION['salary'],$_SESSION['education'],$_SESSION['from'],$_SESSION['to'],$_SESSION['district'],$_SESSION['country_liv']);
    $post=$_SESSION['post'];
 echo $post[9]; //printing the country value
$page = (int)(!isset($_GET["page"]) ? 1 : $_GET["page"]);
if ($page <= 0) $page = 1;


$per_page = 5; // Set how many records do you want to display per page.
$startpoint = ($page * $per_page) - $per_page;

$statement = "`tbl_member` where member_id!=$member_id  AND TIMESTAMPDIFF(YEAR, dob, CURDATE())>='$post[6]' AND 
    TIMESTAMPDIFF(YEAR, dob, CURDATE())<='$post[7]' AND gender Like '$post[0]%' AND star LIKE '%$post[1]%' AND caste LIKE '%$post[2]%' AND  mari_status LIKE '%$post[3]%' AND education LIKE '%$post[5]%' AND city_town LIKE '$post[8]%' AND month_income LIKE '%$post[4]%' AND country_liv LIKE '%$post[9]%'"; 


  $results=mysqli_set_charset($conDB, "utf8");
$results = mysqli_query($conDB,"SELECT * FROM {$statement} LIMIT {$startpoint} , {$per_page}");

现在我已编辑...这是我的全部编码，请帮助我......

我想在结果中显示特定国家/地区...

我可以获取用户输入，但是当我使用此查询时它不起作用。现在我已经编辑了...这是我的全部编码，请帮助我......

我想在结果中显示特定国家/地区...

我可以获取用户输入，但是当我使用此查询时它不起作用..

Answer 1

I'M changed the statement this :    

$statement = "`tbl_member` where member_id!=$member_id  AND TIMESTAMPDIFF(YEAR, dob, CURDATE())>='$post[6]' AND 
        TIMESTAMPDIFF(YEAR, dob, CURDATE())<='$post[7]' AND gender Like '$post[0]%' AND star LIKE '%$post[1]%' AND caste LIKE '%$post[2]%' AND  mari_status LIKE '%$post[3]%' AND education LIKE '%$post[5]%' AND city_town LIKE '$post[8]%' AND month_income LIKE '%$post[4]%' AND country_liv LIKE '%$post[9]%'"; 

对此:

$statement = "`tbl_member` where month_income LIKE '%$post[4]%' AND TIMESTAMPDIFF(YEAR, dob, CURDATE())>='$post[6]' AND 
    TIMESTAMPDIFF(YEAR, dob, CURDATE())<='$post[7]' AND  member_id!=$member_id AND country_liv LIKE '%$post[9]%' AND gender Like '$post[0]%' AND star LIKE '%$post[1]%' AND caste LIKE '%$post[2]%' AND  mari_status LIKE '%$post[3]%' AND education LIKE '%$post[5]%' AND city_town LIKE '$post[8]%' "; 

谢谢 friend ...它对我有用