ScoobyNet.com - Subaru Enthusiast Forum

ScoobyNet.com - Subaru Enthusiast Forum (https://www.scoobynet.com/)
-   Computer & Technology Related (https://www.scoobynet.com/computer-and-technology-related-34/)
-   -   ASP Poll Script.... (https://www.scoobynet.com/computer-and-technology-related-34/315041-asp-poll-script.html)

Steaming Wizard 30 March 2004 03:51 PM

ASP Poll Script....
 
Hey folks.

I have just spent an afternoon searching for a freeware ASP poll srcipt that I can use for one of the sites I administer at work.

The problem is, I need it to be able to handle 57, yes 57 different responses. The idea is, there are 57 photos. Visitors to the site need to be able to vote for their favourite, and once voted, be redirected to a results page, with hopefully a graph showing how many votes for each.

Any suggestions will be gratefully received.

Cheers

Brian

Dream Weaver 30 March 2004 04:04 PM

3 tables - pictures, users, results

pictures holds each pics unique ID and URL.
users holds their email address, username etc so they can only vote once.
results holds the picture ID and the number of votes.

Each time someone votes, update the results table and increment the votes by 1 for that pic ID. Then flag that the user has already voted.

Then to interrogate the data, simply select the info from the results and pictures table. Your graph can be represented using 1x1 pixel gifs with the image values (W & H) based on the results value for that image.


All times are GMT +1. The time now is 02:49 PM.


© 2024 MH Sub I, LLC dba Internet Brands