Miscellany

<HTML>
<HEAD>
<TITLE>flaf</TITLE>
</HEAD>
<style type="text/css">
<!--
.table1 {float: left; background-color:#00FF00; width: 18px; height:18px; font-size:medium; text-align:center;}
.table2 {float: left; background-color:#00FF00; width: 12px; height:12px; font-size: x-small; text-align:center; margin-top: 6px; _margin-top: 7px; /*IE SUX0rz!*/ }
.clearit {font-size: 0;	line-height: 0;	height: 0; clear: both;}
-->
</style>
<BODY>
<?php
$today = date('j');
$thismonth = date('m');
$thisyear = date('Y');
$tomorrow = $today+1;

$result = mysql_query("SELECT username from my_tc_templates where substring(template, $today, 1) = 'G' and year = $thisyear and month = $thismonth")
or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$toons = $row[username];
if($toons)$i++;
}
?>
<?php
$result2 = mysql_query("select count(*),my_tc_user_group.groupname from my_tc_user_group,my_tc_templates where substring(my_tc_templates.template, $today, 1) = 'G' and year = $thisyear and month = $thismonth and my_tc_templates.username = my_tc_user_group.username group by groupname") or die(mysql_error());

while ($row = mysql_fetch_assoc($result2)) { 
$var = $row['groupname']; $$var = $row['count(*)'];
}
?>
<?php
echo '<div class="table1" id="table1">';
echo "<a href=\"#" onmouseover=\"return overlib('$i are good to go today. <br> Druids: $Druids <br> Hunters: $Hunters <br> Mages: $Mages <br> Priests: $Priests <br> Rogues: $Rogues <br> Shamans: $Shamans <br> Warlocks: $Warlocks <br> Warriors: $Warriors',FGCOLOR, '#000000',TEXTCOLOR, '#FFFFFF',BGCOLOR, '#846410');\" onmouseout=\"return nd();\"><span style=\"color: #000000;\">$i</span></a>";
echo '</div>';
echo '<br class="clearit">';
?>
</BODY>
</HTML>