I am looking for someone who is fluent in PHP and mySQL to modify a database driven website. This site started out as a simple zip code (with mileage calculation) and category search site, but as my client began selling listings, he realized that his vendors wanted more than one listing. For example, some of them want to be listed in multiple zip codes, multiple cities, multiple counties and multiple states. There is a table in the database to hold the multiple zip code listings but if a vendor wants to be listed in 3 counties, having my client enter a zip code listing for each zip code just doesn't make sense. This could end up being a couple hundred zip codes easy just for that one vendor. Basically I need to have a site that allows a visitor to enter a zip code and select a category and have the matches print for anyone in that zip code(s) who also may have paid for a city(s), county(s) or state(s) listing in that particular category.
There is also an admin section to easliy add/delete/edit vendors, listings, categories and so on. This will also need to be updated according to the modifications above. In addition, I will need a second phone # column (label on result form “additional phone”) and a text box column (no label on result form) added to the vendors table in the database, result page and corresponding pages in the admin section.
Lastly, there is a bug in the admin section that needs corrected. On the delete zip code listing and delete category listing pages, the delete action deletes all of the listings associated with the selected client instead of just the one selected listing.
I am looking for someone who can get started right away.
If any of this is unclear or if you have any questions, pleasae let me know.