PHP Code:

$Test = ("SELECT Test, SUM(IF(Test = 'Til', 1,0)) AS `T`, SUM(IF(Test = 'Sil', 1,0)) AS `S` FROM `Show` GROUP BY `Test`"); 

$get = mysqli_query($mysqli, $Test)or die("Error: ".mysqli_error($mysqli)); 

$gg = mysqli_fetch_array($get); 

echo $gg['T']; 
echo $gg['S']; 


When I try something like this, I can get the correct result for the first sum, but after that, it reverts to 0. I was wondering how I could get this to work for both. Thanks again.

try this code

select test, sum( case test when 'Til' then 1 else 0 end) as T,
sum(case test when 'Sil' then 1 else 0 end) as S
from test
group by test

That will get the first one, but then will display 0 for the next.

I have tested this code on mysql,It's ok.I can get the right result.

Are you ordering it or anything?