I need a website building using php and mysql that allows visitors to vote. In the middie of the main page it will display 2 random items - one from table1 and one from table2. The user votes on "are these 2 items good together or not" - a simple yes or no. Their vote is stored and the page is refreshed - showing the next 2 random items for voting.
Most rows in table1 and table2 will have equal chance of randomnly being chosen each time. However some rows need to have an indicator that tells the system to give them a higher chance of being picked. I need to tweak this indicator when the site is live to raise or lower the chances of those rows being picked.
Down the side of the main page is the top 10 pairs, each showing how many people voted for that pair. Every time the page is refreshed this list will update. It is also possible to view the top 100 on a seperate page, which will also have links to show 101-200, 201-300,...etc.
The look/feel of the site is not important but it must be delivered so as to be easy for me to tailor the look/feel (I am skilled in html, php but need it to be quick to tailor). No management screens for the DB are needed as I can tweak data using phpmyadmin on my own server.
I need this site in the next few days.
regards
Steve