Im new to the forums, and wanted to kick off by asking a coding question.
Im building a php script and need help with mysqli scripting.
I have a database similar to the following:
dep_airport arr_airport flt_num
LHR JFK 100
LHR FRA 200
JFK MIA 300
The user for instance wants to fly from MIA to FRA, however theres no direct connection, so a simple query such as
SELECT * FROM schedules WHERE dep_airport = 'MIA', arr_airport = 'FRA'
would not work as the user would need to stop over in JFK and LHR to catch a connecting flight.
How can I structure a php query for it to find and display that connection?
Many Thanks !