[SOLVED] Calling all airport data (name, lat and lon) in a .xml file

[James142]

Hello.

I was wondering if it was possible to call all the airport information from the database into a .xml file? for example:

Dublin airports lat/long is: 51.5002/-0.1262

So I wish to display:

<lines>
<line lat="51.5002" long="-0.1262" width="1" name="Dublin" alpha="40"></line>
</lines>

Any help is appreciated,

James

[James142]

Would I have to make a php file to create the .xml file?

[Strider]

What is the xml file to do?

[James142]

What is the xml file to do?

Create a flash map showing all flights from each of the hubs...

[Strider]

Looks like you will have to create a php file to create the xml file.

[Jeff]

Mr. Barrett,

Try locating the Airport Table here in the forums. I believe it shows you the complete list of every airport in your database as well as the Lat/Lon. You can then see how it is pulling that info, and tweak your code to work on the page you want.

[James142]

Mr. Barrett,

Try locating the Airport Table here in the forums. I believe it shows you the complete list of every airport in your database as well as the Lat/Lon. You can then see how it is pulling that info, and tweak your code to work on the page you want.

Or I could have just used my brains and searched it on google. Found it thanks