Reply to thread

Message

<blockquote data-quote="Rasyr" data-source="post: 2061520" data-attributes="member: 2855">Actually, this would be very easy to setup. a couple of tables in a database, and a few queries to pull the needed information. I am not expert in SQL (just have a basic understanding of it), but even I can see how to set it up. Round 1 - do a query pulling the first choice for each product in each category.Round 2 - do a query which pulls the first choice votes for each product and totals them, except for poducts that are dropped. The second part of the query goes to them and pulling the second item from the row and adds it to the proper tallies..Continue on until winner is decided...Yes, it is actually a slight bit more complicated than that, but you get the general idea. Anybody who is decently versed in writing SQL can easily come up with the proper queries to get the information.Combine this with some javascript do run comparisons, and to call further queries if there is a tie, and it could be set up so all that has to be done is to check an admin page to get the winners.</blockquote>

[QUOTE="Rasyr, post: 2061520, member: 2855"] Actually, this would be very easy to setup. a couple of tables in a database, and a few queries to pull the needed information. I am not expert in SQL (just have a basic understanding of it), but even I can see how to set it up. Round 1 - do a query pulling the first choice for each product in each category. Round 2 - do a query which pulls the first choice votes for each product and totals them, except for poducts that are dropped. The second part of the query goes to them and pulling the second item from the row and adds it to the proper tallies.. Continue on until winner is decided... Yes, it is actually a slight bit more complicated than that, but you get the general idea. Anybody who is decently versed in writing SQL can easily come up with the proper queries to get the information. Combine this with some javascript do run comparisons, and to call further queries if there is a tie, and it could be set up so all that has to be done is to check an admin page to get the winners. [/QUOTE]

Verification