mysql - trying to take sql data and then define just one of the rows in a php variable -


Hello, I have a description of two car drivers that draws from the database but then I just want to catch one of the two I can take the details of both the drivers by echoing it in Php and using the one-time loop they resonate both of them, but not just targeting one of them:

The code below I repeat the two records using I Is there any way to catch one?

  while ($ row = mysql_fetch_array ($ result)) {dumb "a driver: 
"; Echo "name:" $ line ['first name'] "" $ line ['last name']. "& Lt; br / & gt;"; Echo "Latitude:" $ line ['CoordLat'] "& Lt; br / & gt;"; Echo "Longitude:" $ line ['CoordLong']; $ Driverlat = $ row ['CoordLat']; $ Drylang = $ line ['coord long']; } // End of the loop

simply remove while Loop?

  $ line = mysql_fetch_array ($ result)) echo "A driver: 
"; Echo "name:" $ line ['first name'] "" $ line ['last name']. "& Lt; br / & gt;"; Echo "Latitude:" $ line ['CoordLat'] "& Lt; br / & gt;"; Echo "Longitude:" $ line ['CoordLong']; $ Driverlat = $ row ['CoordLat']; $ Drylang = $ line ['coord long'];

Comments