php - 根据已完成的搜索来搜索mysql数据库

Question

我有 3 个链选择框，它们从表中的同一行数据返回三个值:$drop、$drop_2 和 $drop_3，并且我想运行 mysql 查询以从该行的另一列返回值在表中。我可以将值直接“回显”到页面，但我想使用数组值，然后在“while”循环中从不同的表生成匹配结果。我进行了以下设置，如果有人能告诉我为什么它不起作用，我将不胜感激!

<h1>Search Results</h1>

<table>
<tr>
<th>Name</th>
<th>Number</th>
<th>Description</th>
</tr>

<?php

$search_results = mysql_query("SELECT id_sensor FROM vehicles_new WHERE make='$drop' AND model='$drop_2' AND year='$drop_3'");

while($result = mysql_fetch_array($search_results)){        

    echo $result['id_sensor']; //This is displaying the value I need to use in the next query
    ?>

<?php

$sql = mysql_query("SELECT * FROM products WHERE id='$result'");

    while($row = mysql_fetch_assoc($sql)){
?>
    <tr>
    <td><?php echo $row['id']; ?></td>
    <td><?php echo $row['part_id']; ?></td>
    <td><?php echo $row['description']; ?></td>
    </tr>
<?php
    }
?>

    <?php
    }
?>
</table>

提前致谢，乔

Answer 1

改变这个

$sql = mysql_query("SELECT * FROM products WHERE id='$result'");

到此

$sql = mysql_query("SELECT * FROM products WHERE id='" . $result['id_sensor'] . "'");