如何使查询在任何列表框选择更改上运行

if(isset($_POST['select'])){
 $newselection=$_POST['select'];
 $query  = "SELECT count(*) FROM listings where description=" . $newselection. "";
 $result = mysql_query($query);
 while($row = mysql_fetch_array($result, MYSQL_ASSOC))
 {
     echo "Number of rows: {$row['count(*)']}";
 }
}

目前它只在按下提交按钮时工作
我想避开js。。
*另外,我还有其他运行ajax的查询
if(isset($_POST['button1'])){
$selection=$_POST['select'];
$queryres  = "SELECT * FROM listings where description=" . $selection. "";
$resultres = mysql_query($queryres);
while($rowres = mysql_fetch_array($resultres, MYSQL_ASSOC))
 {

    echo "<div style='position: absolute; left: 294px; top: 16px;' title='Site map' class='myclass'> <img src={$rowres['picture1']} alt=''/></div>" ;
    echo "<div style='position: absolute; left: 294px; top: 116px;' class='myclass'>Number:{$rowres['number']} <br>Description : {$rowres['description']} <br><br></div>" ;
 }
 }

最佳答案

试试这个(它与php代码无关,它是html)

<option onchange="this.submit();">

09-10 23:55
查看更多