title: Select * from table where id=(a lot a different values)...how to write a query that can do this function?
body: <p>I have two tables register and bar which are linked with the field id_register.I have the following query </p> 
  
  <pre><code>$query="select * from register where register.id_register=(select bar.id_register from bar where bar.confirm='1' AND bar.confirm2='0') ";&lt;br&gt;&lt;br&gt;
  
  $run=mysql_query($query);&lt;br&gt;
  while ($row=mysql_fetch_array($run))&lt;br&gt;
  { 
      echo " $row[id_register]." ; &lt;br&gt;
      echo " $row[another-field]." ;  
  }
  </code></pre>
  
  <p>I need help to solve this  problem :<br>This query release an error because when search for register.id_register <strong>(where register.id_register=(select bar.id_register from bar where bar.confirm='1' AND bar.confirm2='0'</strong>) founds a lot of id values on DB.<br>How can i solve this? Is there another mysql function that i can use to select data in the right way?? </p>