amagicdrag0n
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by amagicdrag0n
-
-
Hi Guy's
MySQL version 5.5.40
PHP 5Drupal 7Website is hosted on my own Ubuntu Server
Firstly can I say that I am a complete newbie and am not really a coder, I'm at an age where it is quite difficult to learn new things.I have just built my first website that tracks aircraft around the UK at www.donnyradar.co.ukWhat I would like to do is take a point on a map, like the location of an airbase and track aircraft that are within a 10 mile radius of that point.I have a table called 'livedata' that is populated by data taken from aircraft's adsb transponder, this includes the aircraft's ICAO hex code, Callsign, Altitude, Heading and Position (Latitude/Longitude)
Q1. Is it possibleQ2. If so, how would I do it? Thanks in HopeDave
Point on a map
in SQL
Posted
Thanks Foxy Mod
I think that you have mis-understood slightly :-)
There will be no interaction from the user. I have the co-ordinates of the airbases, my plane plotting software gives me the co-ordinates of the aircraft, I just need to be able to query if any aircraft is within the radius I require from the airbase.
As this is just a hobby thing, I'll probably have to drop the idea as I don't have anywhere near the skills it looks as though I would need
Regards
Dave