Gossamer Forum: General: Databases and SQL: Re: [Andy] Any insight into Rolling Sums in SQL: Edit Log

Hey Andy,

Can you tell I am advancing my get in trouble level? LOL

this is what I started with

Code:

         print ("Date $row[dayt]|<a href=mailto:$row</a>|");  
              if ($winner == 1)  
         print ("prize 1");  
                   else if ($winner == 2)  
         print ("prize 2");  
                   else if ($winner == 3)  
         print ("prize 3");  
                   else if ($winner == 4)  
         print ("prize 4");  
         print ("|$winner Match|");  
         print ("USD|Ticket-$row[ticket]|Message<br>\n");

I am wanting the if statements to provide a running total per player.
I was thinking it would be easier if the database did the running total,
then simply print that total, what do you think?

If a player, played 3 times in a week I could get a running total of the players winnings.

General: Databases and SQL: Re: [Andy] Any insight into Rolling Sums in SQL: Edit Log

Here is the list of edits for this post

Last edited by:

Edit Log: