title: trying to take sql data and then define just one of the rows in a php variable
body: <p>Hi I have the details of two car drivers getting pulled from a database but then I want to just grab one of the two and echo it out in php. I am able to take both drivers details and echo them both out using a while loop but not target just one of them:</p>
  
  <p>By using the code below I echo out both records. Is there a way to just grab one of them?</p>
  
  <pre><code>while($row = mysql_fetch_array($result)) 
  
  
  {
  echo "A driver:&lt;br /&gt;";
  echo "Name:". $row['FirstName'] . " " . $row['LastName']."&lt;br /&gt;"; 
  echo "Latitude:". $row['CoordLat']."&lt;br /&gt;"; 
  echo "Longitude:". $row['CoordLong'];
  
  
  $driverlat = $row['CoordLat'];
  $driverlong = $row['CoordLong'];
  
  
  
  }//end of while loop
  </code></pre>