Re: INSERT, UPDATE and Groundhogs

2001-11-03 Thread Paul DuBois
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

INSERT, UPDATE and Groundhogs

2001-10-26 Thread Christopher Book
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')

INSERT, UPDATE and Groundhogs

2001-10-26 Thread Jonathan M. Morgan
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