Re: SUM problem.
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 ?