title: How to explode() value and save it in a variable?
body: <p>Right now I'm working on a new homepage for a museum, and I have to use the old database (because it has over 70k entries). </p>
  
  <p>My job now is to change the values in the "dias" table (supporter row) from full names of the supporters to their IDs (supporter table).</p>
  
  <p>Right know I'm using this code:</p>
  
  <pre><code>$result = mysql_query("SELECT pate FROM dias");
  
      while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
              $pate = explode(" ", print_r($row[0]));
      echo "&lt;br&gt;";
      }
  </code></pre>
  
  <p>If I now put in <code>$pate[0]</code>, I only get "1" as output (along with the names from the print_r).</p>
  
  <p><strong>My question is:</strong>
  How can I split the names and save them seperately in a variable, because I think I need this to be able to compare the names with the one in the supporter table and to write the ids in the supporter row in the "dias" table.</p>
  
  <p>If you need more infomration, feel free to ask.</p>