Gossamer Forum
Home : General : Databases and SQL :

Re: [Andy] Any insight into Rolling Sums in SQL

Quote Reply
Re: [Andy] Any insight into Rolling Sums in SQL In reply to
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.

Last edited by:

SandraR: Oct 2, 2009, 12:11 AM
Subject Author Views Date
Thread Any insight into Rolling Sums in SQL SandraR 16161 Oct 1, 2009, 11:26 PM
Thread Re: [SandraR] Any insight into Rolling Sums in SQL
Andy 15865 Oct 1, 2009, 11:36 PM
Thread Re: [Andy] Any insight into Rolling Sums in SQL
SandraR 15842 Oct 2, 2009, 12:05 AM
Thread Re: [SandraR] Any insight into Rolling Sums in SQL
Andy 15883 Oct 2, 2009, 12:17 AM
Thread Re: [Andy] Any insight into Rolling Sums in SQL
SandraR 15875 Oct 2, 2009, 12:23 AM
Thread Re: [SandraR] Any insight into Rolling Sums in SQL
Andy 15822 Oct 2, 2009, 12:29 AM
Post Re: [Andy] Any insight into Rolling Sums in SQL
SandraR 15747 Oct 2, 2009, 12:35 AM