Issue with fetch row

view full story

http://www.daniweb.com – Hello there, I'm not getting the result's I want with my code. So this is my table: P_ID Latitude Longitude 9001 15 10 9002 23 54 9003 2 23 9004 23 12 9005 54 23 And here is my code: //connect //ordering the latitude $query="SELECT Latitude FROM Position ORDER BY Latitude ASC"; $result=mysql_query($query); if (!$result) {     echo 'Could not run query: ' . mysql_error();     exit; } $row = mysql_fetch_row($result); echo $row[0]; echo $row[1]; echo $row[2]; Issue: I want to be able to retrieve any row I want but this code keeps giving me back only the first result. In this specific example the result is ''2'' which is the Latitude of the row 0 since I order the column ASC. Do you have any suggestion ? To get other values? Thank you (General)