ASP Poll Script....
30 March 2004, 03:51 PM
#1
Scooby Regular
Thread Starter
Join Date: Oct 2003
Location: sunny sussex
Posts: 9,142
Likes: 0
Received 0 Likes
on
0 Posts
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
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
30 March 2004, 04:04 PM
#2
Scooby Regular
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.
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.
Thread
Thread Starter
Forum
Replies
Last Post