title: Treeview populated from database
body: <p>I have been trying to figure out how to create a treeview which is populated from a database using various examples I have come across but have not been successful so far.</p>
  <p>My database is structured like:</p>
  <p><code>id |  parent_id  |  title  |  Urgency</code> (Urgency is not implemented yet)</p>
  <p>The end result should generate a treeview where the value of urgency dictates the image used for each item.</p>
  <p>The code I have been trying to utilise lately is:</p>
  <pre><code>&lt;hmtl&gt;
  &lt;body&gt;
  &lt;?php
  
  function get_children($parent, $level = 1)
  {
  $result = mysql_query('SELECT * FROM treeview_items WHERE parent_id = '.$parent);
  $result2 = mysql_fetch_array($result, MYSQL_ASSOC);
  #for avoiding some errors
  if(mysql_num_rows($result) &gt; 0)
      #start the list
      echo '&lt;ul&gt;';
      foreach($result2 as $row) {
          #print the item, you can also make links out of these
          echo '&lt;li&gt;'.$row['title'].'&lt;/li&gt;';
          #this is similar to our last code
          #this function calls it self, so its recursive
          get_children($row['id'], $level+1);
      }
      #close the list
  echo '&lt;/ul&gt;';
  }
  
  mysql_connect('localhost', 'root');
  mysql_select_db('test');
  
  $result = mysql_query('SELECT * FROM treeview_items');
  $result2 = mysql_fetch_array($result, MYSQL_ASSOC);
  
  #for avoiding some errors
  if(mysql_num_rows($result) &gt; 0) {
  #start the list
  echo '&lt;ul&gt;';
  foreach($result2 as $row) {
      #print the item, you can also make links out of these
      echo '&lt;li&gt;'.$row['title'].'&lt;/li&gt;';
      #recursive function(made in next step) for getting all the subs by passing   
   id of main item
      get_children($row['id']);
  }
  #end the list
  echo '&lt;/ul&gt;';
  #some message if the database is empty
  }
  else echo 'No Items';
  
  #clear the memory
  mysql_free_result($result);
  ?&gt;
  &lt;/body&gt;
  &lt;html&gt;
  </code></pre>
  <p>Basically the code I have doesn't work. What can I try to fix it?</p>
  <h2>Edit</h2>
  <p>I altered some of the code to fix a couple of errors
  So now what I see is:</p>
  <ul>
  <li>1</li>
  <li>2</li>
  <li>5</li>
  </ul>
  <p>Warning: Invalid argument supplied for foreach() in C:\Program Files\EasyPHP-5.3.9\www\test.php on line 13</p>
  <p>repeated 100 times until it aborts. Not sure why, because both <code>foreach()</code> in the code are the same, but the one inside the function doesn't work.</p>