title: Getting the first row of the mysql resource string?
body: <p>Here is my problem.
  I need more than one row from the database, and i need the first row for certain task and then go through all the list again to create a record set.</p>
  
  <pre><code>$query = "SELECT * FROM mytable";
  $result = mysql_query($query);
  
  $firstrow = //extract first row from database
  //add display some field from it
  
  
  while($row = mysql_fetch_assoc($result)) {
     //display all of them
  }
  </code></pre>
  
  <p>Now, how to extract just the first row?</p>