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')
and then to get the tally for that vote do :
select name, count (*) from table group by name.
if you only want the tally for one vote than just add a WHERE clause.
Chrsi
>>>>>>>>>>>>>>
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
