title: how to retrieve row value using php mysql
body: <p>source code:</p>
  
  <pre><code>$display = 1004;
  $result1 = mysql_query("SELECT id, username FROM users where parentid=$diplay");
  $resrow = mysql_fetch_row($result1); 
  $g = $resrow[0]; 
  $g1 = $resrow[1]; 
  $g2 = $resrow[3]; -error not display
  $g3 = $resrow[4];
  $g4 = $resrow[5];
  
  
  echo "ID: $g";
  echo "ID: $g2";
  echo "ID: $g3";
  echo "ID: $g4";
  </code></pre>
  
  <p>i have to show 1005, 1007, 1008 but i can retrieve $g value only:</p>
  
  <p>ans: 1004 daniel</p>
  
  <p>how i can show other values 1007,1008</p>
  
  <p>Table</p>
  
  <pre><code>id           ----name  -----    parentid
  -----------------------------------
  1004            daniel         1003
  1005            peter          1004
  1007            michael        1004
  1008            sam            1004
  </code></pre>
  
  <p>ans:</p>
  
  <pre><code>        $g
          1004
       /        \
      g2         g3   
     1005       1007
  </code></pre>