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