Create a dynamic Flash graph application that displays flight ticket prices in a graphical format. All date and price data comes from our database in a simple sql command. The graph should be good looking, have horizontal scrolling and automatically set the y axis level based on the price data.
More Detailed information:
We run a flight price comparison site. Our database has price information for each destination and the idea is to display it graphically so that users would see how the price can change over time or depending on the weekday. One possibility is to use a bar type graph, or dots that are connected. Some less popular destinations have price data for only some days so connected dots or bars may be the best solution.
The graph will be 627 pixels wide and this would show maybe 60-90 days in the x axis. User should have a possibility to scroll right to see more, with the maximum being 180 days. X axis should show week numbers and month names: the idea is to let user see if a Monday flight is more expensive or if September flights are a lot cheaper than August.
The possibility to change colors in an [url removed, login to view] file (or similar) would be great.
The attached zip file is an example of the data we get from our database. It shows time of departure in Unix time format and the price. Prices are comparable because we only search for prices for 1 adult. The starting point for this project is a php file we provide that makes the mysql search and returns an mysql array. The example is in CSV format but I think the php will return an array. Notice that the first dates have already passed so those can be ignored.
I know basic php+mysql but nothing on Flash. This should be a fun and not too big project for a Flash guru : )