title: How to show all data one after another from mysql_fetch_array() in php
body: <pre><code>    $sql="SELECT userId FROM eventmember WHERE eventid='$event_id';";`
      $resultset = mysql_query($sql);
      $row = mysql_fetch_array($resultset); 
  </code></pre>
  
  <p>I got specific userid from specific event column like <code>eventid==&gt; eid-01(us-0, us-3,...)</code>,</p>
  
  <pre><code>    $num_row = mysql_num_rows($resultset);
      while($row) {           
        for($i = 0; $i&lt;$num_row; $i++) {          
          $sql = "SELECT userId, firstName FROM userinfo WHERE userId='$row[$i]';";
          $resultset = mysql_query($sql);
          $row22 = mysql_fetch_array($resultset);
          $us_id = $row22['userId'];
          $us_name = $row22['firstName'];
  
          echo "&lt;tr&gt;";
          echo "&lt;td&gt;ID:&lt;/td&gt; &lt;td class='text2' align='center' colspan='2'&gt;
          &lt;b&gt; $us_id &lt;/b&gt;
          &lt;/u&gt;&lt;/td&gt;";
          echo "&lt;/tr&gt;";
          break;
        }
        $row = mysql_fetch_array($resultset);
      }
  </code></pre>
  
  <p>On that code I got only one userid info but there is more userid against one event.</p>