Someone

$number = date('j')-1;
/*
select my_tc_user_group.groupname, my_tc_templates.username from my_tc_user_group,my_tc_templates where my_tc_templates.username = my_tc_user_group.username { where year=2006, month=08, day=9,F=yes } group by username
*/
$result = mysql_query("SELECT template,username FROM my_tc_templates WHERE year = 2006 AND month = '08'")
or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$template =	$row[template];
$toons = $row[username];

if($template{$number}=='F')$i++;
}
$i= $i-1;
echo "<table bgcolor=#00FF00>";
echo "<tr>";
echo "<td>$i Gtg!</td>";
echo "</tr>";
echo "</table>";