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 so that you can perform time-based analysis of poll activity."
How does one tally the vote (UPDATE) and insert a new record for each vote?
The original MySQL table is as follows:
CREATE TABLE
(
name CHAR(10) NOT NULL,
tally INT UNSIGNED NOT NULL DEFAULT 0
)
The vote tally is updated like this:
$dbh->do ("UPDATE groundhog SET tally = tally + 1 WHERE name = ?",
undef, $name);
I updated the table to include an auto incremented vote_id(PRIMARY KEY) as
well as a timestamp. But how do you log each vote and tally the vote?
Thanks!
JMM
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
