像这样的?
<?
$conn = mysqL_connect('localhost','root','');
mysql_select_db('dbname');
$SQL = "select * from TableName where (field1='$term1') and (field2='$term2')...";
$result = mysql_query($SQL, $conn);
while($arr = mysql_fetch_array($result))
{
echo $arr[fieldname]."<br>\n";
}
mysql_close($conn);
?>
<?
$conn = mysqL_connect('localhost','root','');
mysql_select_db('dbname');
$SQL = "select * from TableName where (field1='$term1') and (field2='$term2')...";
$result = mysql_query($SQL, $conn);
while($arr = mysql_fetch_array($result))
{
echo $arr[fieldname]."<br>\n";
}
mysql_close($conn);
?>
如果条件是只要第一个条件成立即可的话~~你是不是要重写sql语句呢?
最好用以下方法来做
if ( 条件1成立 ) $res = mysql_query("select * from TableName where field1='$term1' ");
if ( 条件2成立 ) $res = mysql_query("select * from TableName where field2='$term2' ");
...
其他一样 这样做就很灵活