|
$sql = "select * from self_acting ORder by activity,signin asc";
$sqlquery = mysql_db_query($dbname, $sql);
$num_row = mysql_num_rows($sqlquery);
if($num_row != 0)
{
print " ";
print "";
/*print "";
print "- Running Activity - | ";
print " ";*/
print "";
print "# | ";
print "Section | ";
print "Student ID | ";
print "Name | ";
print "Date | ";
print "Sign In | ";
print "Activity | ";
print " ";
$c=1;
while($array = mysql_fetch_array($sqlquery))
{
//$sql1 = "select * from self_booking where stuid = '$array[stuid]'";
//$sqlquery1 = mysql_db_query($dbname, $sql1);
//$record = mysql_fetch_array($sqlquery1);
//$time = $record['time'];
if($bg == "#EFEBFE") { //ส่วนของการ สลับสี
$bg = "#FEFEF1";
} else {
$bg = "#EFEBFE";
}
print "";
print "".$c." | ";
print "".$array['section']." | ";
print "".$array['stuid']." | ";
print "".$array['name']." | ";
print "".$array['date']." | ";
print "".$array['signin']." | ";
print "".$array['activity']." | ";
print " ";
$c++;
}
print "";
print" ";
}
mysql_close();
?> |