I'm currently working on a project where i need to get some values from a database (easy).
$query = mysql_query("SELECT * FROM details")
Then i need to work out the distance using eastings & northings from the OS datapack (easy).
while($details = mysql_fetch_array($query))
$distance = getDistance($u_easting, $u_northing, $c_easting, $c_northing)
$distance Could give a number like 101.262 or 12.344
I'm getting stuck where i need to order the allowed values (under a certain range) and display them...
Any ideas, all i can think of is reentering them into a temp database and pulling them out in order, but idealy i want to avoid this as it is too time consuming?
Thanks in advance...