\n";
echo "";
echo "\n";
$maxcol = 0;
$meetings = array();
$res = mysql_query("DESCRIBE shs_members");
echo "| Name | ";
while($dat = mysql_fetch_row($res))
{
$title = $dat[0];
$meetings[] = $title;
// if it is NOT the user id column, then display
if(ereg("meet",$title))
{
$maxcol++;
$title = str_replace("meet", "", $title);
echo "$title | ";
}
}
echo "Asistencia Total | ";
echo " \n";
$res = mysql_query("select * from shs_members order by name asc");
while($dat = mysql_fetch_row($res))
{
$name = $dat[3];
$m = $dat[0];
echo "| $name | ";
$attended = 0;
for($t = 0; $t<$maxcol; $t++)
{
$temp = $dat[$t+12];//+5];
$meet = $meetings[$t+11];//+4];
if (strcmp($temp, "p") == 0){
$attended++;
echo "Presente | ";
}
else{
echo "Ausente | ";
}
}
echo "$attended / $t | ";
echo " \n";
}
echo " \n";
echo " |