MySQL Forums
Forum List  »  Newbie

Re: SUM problem.
Posted by: Patric Andersson
Date: March 15, 2009 10:35PM

Ok, I've made a export of all 3 tables.

Table structure for table lepok_anvandare
Field      Type          Null     Default     Comments     
id         int(10)       Yes      NULL
fornamn    varchar(255)  Yes
efternamn  varchar(255)  Yes
email      varchar(255)  Yes      NULL
nick       varchar(255)  Yes      NULL
telefon    varchar(255)  Yes      NULL
mobil      varchar(255)  Yes      NULL
ort        varchar(255)  Yes      NULL
inaktiv    smallint(6)   Yes      0
Example of a row.
id     fornamn     efternamn    email     nick    telefon   mobil     ort       inaktiv
24     Patric      Andersson    *hidden*  Fjorod  *hidden*  *hidden*  Goteborg  0
Table structure for table lepok_resultat
Field      Type          Null     Default     Comments
id         int(10)       Yes      NULL
turnering  int(10)       Yes
deltagare  varchar(255)  Yes
poang      int(10)       Yes      0
pengar     int(10)       Yes      0
Example of a row
id     turnering  deltagare  poang  pengar
180    22         24         10     0
Table structure for table lepok_turneringar
Field    Type          Null    Default     Comments
id       int(10)       Yes     NULL
namn     varchar(255)  Yes 
datum    date          Yes
typ      varchar(255)  Yes
inaktiv  smallint(6)   Yes     0
Example of a row.
id     namn        datum       typ       inaktiv
22     LiveTorney  2008-03-23  pligan    0
Ok, I hope this is what you where looking for.
I regret nameing some of the things like I did, for example nameing all autoinc to id, instead of userid, torneyid and so on. But this project is my first work with mysql and actually the first time I allso use html forms.... but that's not important. What is important is if this is enough info for you to be able to help me ?

Options: ReplyQuote


Subject
Written By
Posted
March 12, 2009 03:29AM
March 12, 2009 09:52AM
March 13, 2009 07:10PM
March 13, 2009 11:10PM
March 14, 2009 04:01PM
March 14, 2009 06:40PM
March 15, 2009 07:54AM
March 15, 2009 10:41AM
Re: SUM problem.
March 15, 2009 10:35PM
March 16, 2009 09:33AM
March 16, 2009 09:52AM
March 16, 2009 02:46PM
March 16, 2009 04:15PM
March 17, 2009 02:11PM
March 17, 2009 05:03PM
March 17, 2009 06:31PM
March 17, 2009 10:17PM
March 18, 2009 06:03AM
March 15, 2009 05:41PM
March 15, 2009 07:14PM
March 16, 2009 08:34AM
March 18, 2009 12:52AM
March 21, 2009 05:58AM
March 21, 2009 11:13AM
March 22, 2009 05:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.