title: Mysql Update, 2 databases
body: <p>I have 2 MYSQL tables and when I pick up dates from table A which contains only 1 column and lets say 10 rows with dates</p>
  
  <pre><code>    $result = mysql_query("SELECT * FROM A");
      $row = mysql_fetch_assoc($result);
  </code></pre>
  
  <p>And after I want to UPDATE another table B with using this dates from table A            <code>mysql_query("UPDATE B SET something='1' WHERE name='".$row['name']."'")</code>
  So i need to update the second table, but its updating just once with first date from table A, and other 9 its ignoring. So my question is, how to make updating of second table with each date from 1 table?</p>