Need some help calculating win percentage here's my code

[blackgold]

I'm a total newb, but here's my code.  I have a cell colored a certain color if it's a win.  I'm trying to calculate my win percentage.

 

$test1 = mysql_query("SELECT COUNT(*) from mytable WHERE color=#ABD66F * '100'";
$test2 = mysql_fetch_row($test1);
echo "$test2[0]";

[cooldude832]

um wow I don't even see table structure db structure or anything?

 

we could guess at this but it just be pointless

[Barand]

SELECT SUM(IF(color='#ABD66F', 1, 0)) * 100 / COUNT(*) FROM mytable