Mysql PHP database query and display results in a webpage and more

I am not asking for the developer to create an entire site, as I will provide the basic webpage template for the developer to add their scripts into. I want users to be able to query a mysql database. They will be able to search by keyword and display and sort the results by : - most viewed - most downloaded - user rating - newest Or they will just be able to display the items in order based on one of those four criteria listed above. They will also be able to choose how they want the results displayed, - either in a grid format or a list view and lastly how many to show at a time (ex.20 | 40 | 80 | ALL) and provide pagination for the results (previous / 1 / 2 / 3 )etc. The list view will simply be the title, image thumbnail, rating, # downloads listed in a row one after the other and the grid will be displayed with 4 across. You can see examples of this on the webpage of [login to view URL] When the user clicks on one of the items it will take the user to a different page where the title, description, larger size image, number of times the item has been viewed, number of times downloaded, a user rating, and a link to download a file that is related to that item, and a list of the comments left by previous reviewers. On that page, the user can then submit a review, leaving a short message and giving the product a rating on a 1-10 scale. The user will only be able to submit one review per item, as the user will be tracked by either IP or cookie. I ask the developer to help in choosing the best method, either IP, cookie or both. Of course the program will keep track of the number of times an item has been downloaded,viewed, and the ratings it has received. There should also be an admin 'switch' that will turn off/on the ability to leave reviews and also turn off the displaying of the rating You can checkout a very rough example which is not fully functioning at [login to view URL] That page and how it works was done by another developer who could not successfully finish the job nor did it operate in a efficient manner. Include the text, Initiative, in your bid to know you have at least read this far. I will not provide his code as I do not want it used for a base. I will provide the mysql tables but again the tables and their uses can be modified to be more efficient and less taxing on the server. It is unknown at this point if I will allow access to the server, so you may need to develop it on your localhost. The site should use PHP, and Mysql databases and must be safe from any form of mysql/php injection. The site should also be setup to maxmize search engine optimization. There will be followup work for a developer who can successfully complete the job. I will create milestone, but will not release the final payment until all bugs have been fixed and the job requirements met.