Rooms: $row[0] END; } print <<History of $room Station Open Closed Total END; $bgcolor="#CCFFFF"; $query = "SELECT StationNo, count(*) from request WHERE Location = '$room' group by StationNo"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); if (mysql_num_rows($result) >= 1) { while ($row = mysql_fetch_row($result)) { $stationNo = $row[0]; $total = $row[1]; if ($bgcolor=="#FFCCFF"){$bgcolor="#CCFFFF";} else {$bgcolor="#FFCCFF";} $query1 = "SELECT count(*) from request WHERE StationNo = '$stationNo' and Status <> '8' and Location = '$room'"; $result1 = mysql_query($query1, $connection) or die ("Error in query: $query1. " . mysql_error()); $row1 = mysql_fetch_row($result1); $open = $row1[0]; $query1 = "SELECT count(*) from request WHERE StationNo = '$stationNo' and Status = '8' and Location = '$room'"; $result1 = mysql_query($query1, $connection) or die ("Error in query: $query1. " . mysql_error()); $row1 = mysql_fetch_row($result1); $closed = $row1[0]; print << $stationNo $open $closed $total END; } } echo "
