percentage of users predictions

[siriusdave]

hi i have this table...

CREATE TABLE IF NOT EXISTS sf_predictiondata (
lid int(11) NOT NULL default '0',
userid int(11) NOT NULL default '0',
pmatchid int(11) NOT NULL default '0',
predtime timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
phomescore smallint(5) unsigned default NULL,
pawayscore smallint(5) unsigned default NULL,
points smallint(5) unsigned default '0',
isauto enum('Y','N') default 'N',
PRIMARY KEY (lid,userid,pmatchid)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

lay is is like this

lid userid pmatchid predtime phomescore pawayscore points isauto

0 44 15 2008-07-31 14:28:35 3 0 0 N

what i need to know is a code to get a percentage for how many user have made a phomescroce of 2 and pawayscore of 0

ie display like this

1-0 (image) 50%
1-1 (image) 10%
1-2 (image) 20%
1-3 (image) 3%
1-4 (image) 6%
2-0 (image) 10%

like this image

hope you get what i mean just want to show a percentage table of what score users have prediced for a match....

[m_tt]

I think all you need is some basic math. Query your totals and calculate the percentages...

SELECT COUNT( * ) AS `total_scores` FROM `sf_predictiondata`;
SELECT COUNT( * ) AS `total_phomescore` FROM `sf_predictiondata` WHERE `phomescore` = 2;
SELECT COUNT( * ) AS `total_pawayscore` FROM `sf_predictiondata` WHERE `pawayscore` = 0;

phomescore % = total_phomescore / total_scores * 100
pawayscore % = total_pawayscore / total_scores * 100