php - 如何从与数组值相关的其他数据库表中获取值？

Question

在下面的代码中，我将一个数组存储在客户表中。现在我想要来自代理表的数据，但与数组值相关。

 <?php
    $query = "SELECT * FROM customer";
    $no1=1;
    $result = mysql_query($query);

    while($values = mysql_fetch_array($result))
    {
        $values= unserialize($values['part_no']);


        foreach($values as $value)
        {

            echo $value."<br>";
            $query2 = "SELECT * FROM agent WHERE number=$value";
            $result2 = mysql_query($query2);

            while($values2 = mysql_fetch_array($result2))
            {

                echo '' . $row['name'] . '';   // get value from agent table.
                $no1++;
                // echo $no1."<br>";
            }
        }

    } 
?>

Answer 1

试试这个

<?php
$query = "SELECT * FROM customer";
$no1=1;
$result = mysql_query($query);

while($values = mysql_fetch_array($result))
{
    $values= unserialize($values['part_no']);


    foreach($values as $value)
    {
       $search_value = "'".implode("','", $value)."'";
        echo $value."<br>";
        $query2 = "SELECT * FROM agent WHERE number IN ($search_value)";
        $result2 = mysql_query($query2);

        while($values2 = mysql_fetch_array($result2))
        {

            echo '' . $values2['name'] . '';   // get value from agent table.
            $no1++;
            // echo $no1."<br>";
        }
    }

} 
?>