>>
Site Map
>>
Forums
>>
Blocks
Forum module - topics in forum:
Blocks - Having problems with a block? Code doesn't work, get help here.
clan stats block
I'm trying to create a block but dont know where to start.
what I want the block to look like is below
Match type---------W--L--D
Match name -------7--3--0
Match name -------3--2--1
and so on....
the table name is 'Matches'
and what i want to grab off the table is '$match type' and '$result'
where match typr is the match name and result is W,L, or D.
I have no clue how to make it count the '$result' table'. I want it to count up all the wins for that match type and post them under W, the count all the losses and post them under L, and then count all the draws and post them under D.
'$result' = win, loss, or draw....
can anyone help me with this?
It would be best to make it a block you can make a block with html check out the reference guide to html by clicking
here.
sorry I mean that I have a SQL table for our matches. 1 of the columns is result with 3 values ( win lose or draw). Another column is match type which is the match name
What I'm trying to do is have it post all the match names and then all the win lose or draws.
what I want it to post is...
Match-name #of wins #of losses #of draws
4 example
TWL 4v4 ladder 5 2 0
TWL SF Ladder 3 2 0
CAL Open 2 1 0
