title: mysql fetch array
body: <p>I am trying to do a fetch array which pulls out 4 rows and each row has 2 columns. Is there anyway I can define each individual field in each row as a variable individually?</p>
  
  <pre><code>row 1 name, id
  row 2 name, id
  row 3 name, id
  row 4 name, id
  &lt;?php echo $row1name;?&gt;
  &lt;?php echo $row1id;?&gt;
  &lt;?php echo $row2name;?&gt;
  &lt;?php echo $row2id;?&gt;
  &lt;?php echo $row3name;?&gt;
  &lt;?php echo $row3id;?&gt;
  &lt;?php echo $row4name;?&gt;
  &lt;?php echo $row4id;?&gt;
  </code></pre>
  
  <p>Does this make sense?</p>