How can I compute the PCT and GB for a league based on Wins and Losses

[justride]

Hi All,

I have a table with wins and losses. When I select the data I would like to calculate pct (win percentage) and gb (games behind).

My schema is table SCRECORDS, fields: NAME (varchar), WINS(int), LOSSES(int)

I found a query like this but it seems broken.

SELECT @wl_diff = MAX(WINS-LOSSES) FROM SCRECORDS;
SELECT NAME, WINS AS W, LOSSES AS L, WIN(WINS+LOSSES) AS PCT,
(@wl_diff - (WIN-LOSS))  2 AS GB	
FROM SCRECORDS
ORDER BY WINS-LOSSES DESC, PCT DESC;

Thanks!

 

[justride]

I got the pct to work with this query

SELECT NAME, WINS AS W, LOSSES AS L,
TRUNCATE(WINS/(WINS+LOSSES),3) AS PCT,
IF((@wl_diff - (WINS-LOSSES)) = 0,'-',(@wl_diff - (WINS-LOSSES))/2) AS GB
FROM screcords
ORDER BY WINS-LOSSES DESC, PCT DESC;

but GB is all null
Any suggestions?

 

[justride]

Please disregard the solution was found here:

http://www.onlamp.com/pub/a/onlamp/excerpt/mysqlckbk/index3.html