[Sony]

thank you xcoder, hegma and google for your care...i need it similar to what xcoder provided.
i need the system to do the following steps
first get from the user the departure airport A and the arrival airport B
the system will look at all the airports linked to A the results are B C and D
the system will take each possible path
A-B
A-C-B
A-D-B
A-C-D-B
and calculate the distance time and cost for each path
then the user will select to display the results filtered according to his needed criteria maybe he need the cheapest one or maybe the timeless one.
as example:

A-B:
high cost
less time
less distance

A-C-B:
considerable cost
more time
more distance

A-D-B:
Low cost
much more time
more distance

the use of the database is only to save the information, i can code it from scratch but if i could find a similar component available it will be better