Re: Question on adding values together

2004-07-19 Thread SGreen
You will need to create another table. In it you will need a columns identifying what week it is, what team you are documenting, and the statistics you want to store. For individual player statistics, you will need yet another table. This one would have columns identifying the player, what game

Question on adding values together

2004-07-19 Thread MySQL User
Hi I have a hockey pool database and I want to be able to add each weeks totals (goals, assists, etc.) for the players on each team. Example: Team 1 may have Hossa, Redden, and Forsberg. If each of them scored 2 goals and 2 assists for week one, I want to be able to get the total of 12. Team tw

Re: adding values together

2002-11-28 Thread Chris Garaffa
On Thursday, November 28, 2002, at 08:06 AM, BobJ wrote: You appear to be violating the "repeating value" rules of relational database. Multivalue databases (Pick and Pick like) support this concept but they are rather uncommon now. You probably need to create a related table. Actually, you

Re: adding values together

2002-11-28 Thread BobJ
28, 2002 7:48 AM Subject: adding values together > > > > > > Hi, doeas anyone know if it's possible to add 2 or more numeric values > >together that are in the same cell in Mysql: > >IE: i have a cloumn called price that for any entry may contain more > >than o

Re: adding values together

2002-11-28 Thread Fred van Engen
On Thu, Nov 28, 2002 at 12:48:29PM +, Steve Mansfield wrote: > > Hi, doeas anyone know if it's possible to add 2 or more numeric values > >together that are in the same cell in Mysql: > >IE: i have a cloumn called price that for any entry may contain more > >than one value, lets say £1.00 and

adding values together

2002-11-28 Thread Steve Mansfield
Hi, doeas anyone know if it's possible to add 2 or more numeric values together that are in the same cell in Mysql: IE: i have a cloumn called price that for any entry may contain more than one value, lets say £1.00 and £2.00 Is there a way that i can get these values added together ? I know