Do an SQL query based on Form input and Graph results

IN PROGRESS
Bids
33
Avg Bid (USD)
N/A
Project Budget (USD)
$30 - $250

Project Description:
This project calls for a one page .php file that plots numbers from a database on a graph (both bar graphs and line graphs)

The database contains prices and sales details for real estate in a major North American city. Each of the 60+ sub-areas has
sales data for each month.

This one page that you create will show a Form with pull-down options for 4 inputs:
- Property Type (default - all)
- Area (default - all)
- y-coordinate (sales, dollar vol, avg price, med price, etc..)
- x-coordinate (start month, end month)

Once the user makes his or choices, this php page will call itself and show a graph beside the form.
Either a bar graph or a line graph based on what is appropriate. Ex.. bar graph for number of sales, but line graph for avg price.

The input form will still be on the same page, and will show the last options chosen.

Not looking for any designs. Just the form page, query, and graph. Simple. White page, default font.

Check the attached file for a sample of the database, and when making a bid, please include the word 'apple' in the subject
line so I know you've read this post.

Additional Project Description:
03/24/2013 at 21:49 TLT
The sample SQL file I was trying to attach before didn't get attached .. so here is an xml version. If you can't convert it back to sql format, send me your email address and i'll send it to you in a different format.






Skills required:
HTML, Javascript, MySQL, PHP, SQL
Additional Files: mrktwtch.xml
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.