Before I get too in depth I want to point out that we run Joomla 1.7.2. I am not sure if the scope of work I am listing is affected by the Joomla operating system or not. I don't plan to stay on Joomla forever so ideally the completed project would work on both Joomla and an aspx website.
The Project: PHP Application to Call Data
On our website we have a unique page for each US state and then subsequent metro areas in those states. An example would be "/colorado/denver". The purpose of these pages is to boost our local SEO rankings for individual markets. For the past two years we have been using a manually edited template which includes local information for each area - Information such as nearby military bases, colleges, top employers and city/town names within the metro area.
We would like to develop a php application that can query a database and populate each section automatically. In the event that a section does not apply to the specific city/state it would return false and not show. The data would populate around our current design, essentially replacing the hassle of manually editing each time.
Finally, while I have compiled most of this data manually I have not entered it into a database. This is primarily because I don't know how to set it up correctly. I would want the selected freelancer to build the database structure for me so that I can add the values.
You can see an example of what we currently have here: [url removed, login to view]
11 freelancers are bidding on average $427 for this job
We are ready to start working on the project. Please check PMB for our portfolio. That would be pleasure if we can get a chance to work with you. Thanks. AHT!