At 10:05 AM -0700 10/26/01, Jonathan M. Morgan wrote:
>I am working my way through Paul DuBois' excellent book "MySQL and Perl for
>the Web." One of the examples shows how to conduct a poll- vote for your
>favorite groundhog: http://www.kitebird.com/cgi-perl/groundhog.pl
>Paul then suggests modi
Basically for each vote you insert a new record, and then to determine the
tally, you have to do a count(*) on the number of records for each vote.
so have ID | NAME | TIMESTAMP columns.
You log each vote by doing an insert (insert into whatever (name, timestamp)
values ('answer', 'timestamp')
I am working my way through Paul DuBois' excellent book "MySQL and Perl for
the Web." One of the examples shows how to conduct a poll- vote for your
favorite groundhog: http://www.kitebird.com/cgi-perl/groundhog.pl
Paul then suggests modifying the poll "...to log EACH vote and when it
occurred s