title: How can i get value from other db table who releted with array value?
body: <p>In the code below I store one array in customer table. Now I want data from agent table but who related with array value. </p>
  
  <pre><code> &lt;?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."&lt;br&gt;";
              $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."&lt;br&gt;";
              }
          }
  
      } 
  ?&gt;
  </code></pre>