php - 如何使 mysql 搜索允许两个单独的搜索类别？

Question

我正在尝试建立一个搜索栏，允许您通过输入城市或州来搜索企业列表，但无论我尝试添加什么，它都只会按城市搜索。这是可能的还是我应该需要重新开始并使用 mysqli 编写新内容？

这是代码:

.

$result1= mysql_query("SELECT * FROM $table WHERE city LIKE '%$search_term%' ORDER BY state") or die("SELECT Error: ".mysql_error());

$count= mysql_num_rows($result1);

if ($count == 0){ 
echo "<fieldset><b>No Results Found for Search Query '$search_term'</b> 
</fieldset>";

}else{

print "<table border=1>\n";
while ($row = mysql_fetch_array($result1)){  
$images_field= 
$row['images'];
$image_show= "/$images_field";
$city= $row['city']; 
$state= 
$row['state'];  
print "<tr>\n"; 
print "\t<td>\n"; 
echo "<div class='gallery' align=center><a target='_blank' href=". $image_show."><img src=". $image_show." width='300' height='200'></a></div>";
print "</td>\n";
print "\t<td>\n"; 
print "<font face=arial size=4/><div align=center>$city</div></font>"; 
print "</td>\n";
print "\t<td>\n"; 
echo "<font face=arial size=4/>$state</font>";
print "</td>\n";
print "</tr>\n"; 
} 

print "</table>\n"; 
}

.

我尝试在“WHERE city”后面添加“or state”、“AND state”，但这也不起作用。

Answer 1

我认为这个查询应该有效

SELECT * FROM $table WHERE city LIKE '%$search_term%' OR state LIKE '%$search_term%' ORDER BY state