I was wondering if I could get some help on this! I’m looking to pull all of the flights from an airline in the next few months and then upload that information into my own database for use. I’m not too sure where to start this out, and would definitely like some help!
I have this:
INSERT INTO `database_name` (`id`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `aircraft`, `flightlevel`, `distance`, `deptime`, `arrtime`, `flighttime`, `daysofweek`, `week1`, `week2`, `week3`, `week4`, `price`, `payforflight`, `flighttype`, `timesflown`, `notes`, `enabled`, `bidid`)
But could use any of the tips that you all could give me!