php - (PHP) If, Else 无法正确检索条件中的数据

Question

我这里有 If-Else 条件的问题。如下面的代码，

if($status == 'New'){
    $resultx0 = mysql_query("SELECT * FROM application_data_file WHERE Position_ID = '".$pos_id."'  && Application_Status = 'New'  OR 'Received'  OR 'Checking' ");
}
elseif ($status == 'Not qualified'){
    $resultx0 = mysql_query("SELECT * FROM application_data_file WHERE Position_ID = '".$pos_id."'  && Application_Status = 'Failed'  OR 'Not qualified' ");
}
elseif ($status == 'No Condition'){
    $resultx0 = mysql_query("SELECT * FROM application_data_file WHERE Position_ID = '".$pos_id."' ");  
}

"new"和“不合格”条件仅适用于“application_data_file”表中的第一个。当我在条件中输入时，"new"条件将仅检索"new"但不会检索“已收到”或“正在检查”，而“不合格”条件将仅检索“失败”而不会检索“不合格”。

我对此一无所知。条件有问题吗？

干杯。

Answer 1

这样试试

mysql_query("SELECT * FROM application_data_file 
             WHERE Position_ID = '".$pos_id."' 
             AND Application_Status IN ('New','Received','Checking')");