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 ([url removed, login to view]). 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 ([url removed, login to view]). 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 :)
37 freelancers are bidding on average $1167 for this job
Hi, I am available to discuss this project. Since I am in the same time-zone as you are, we can be online during the development of the site which is a big advantage. Best regards from Slovenia, Robi.
Please read our reviews so u have idea.We are expert in bug solving and implement new code.7 years old Web-Development company. please check our site for our work.