You have chosen to sponsor your bid up to a maximum amount of .
I would like a website built which is a mobile phone comparison site. I will try to describe how it looks.
I have attached a copy of the schema. There are 4 tables. Mobile, Network, Plan, MobilePlan.
Mobile table will store the mobile phone information, eg. iPhone 4S.
I have attached an image of the layout of the frontpage (frontpage.png). I want it to show all the mobile phones in the mobile phone table, but if you select a manufacturer, then it will only show the phones from that manufacturer.
When you select a mobile phone, it will then go to the second page and show all the plans for that phone. I have attached a sample of how i want it to look (phonepage.png). To find all the plans you need to look through the phoneplan table and find all records with that phoneid.
At the top i would like to be able to filter by Network and 24 month / 12 month.
The columns that i want to show in the plans are:
Network (eg. Vodafone) - This links to an image located in the NETWORK table
Plan Name - This links to the plan name in the PLAN table
Data - This links to the Data field in the PLAN table
Calls - This links to the Calls field in the PLAN table
Handset Cost - This links to the CostPerMonth24 if 24 month is selected or CostPerMonth12 if 12 month is selected
Total Per month - This is Handset Cost + Monthly Cost from PLAN table
Total Over 12/24 Months - If 24 Months then this is 24 x Total Per Month. If 12 Months is selected then this is 12 x Total Per Month
I will populate the myssql database with test data for you to produce the webpage.
Also, i would like it to look clean and nice :)