Manage | Sign Out

Edit Room Information: $Room

Room:	$Room
Title:
Description:	$row[1]
Status:	END; if ($row[2]=='1') { print <<Enabled Disabled END; } else { print <<Enabled Disabled END; } print <<

END; $query = "SELECT Task, Status from SR_task where RoomNo='$Room' order by Place"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)) { if ($row[1] == '1')$s='Enabled';else $s='Disabled'; print << END; } print <<

Add	Tasks	Status
Edit	$row[0]	$s

END; $query = "SELECT RoomNo, Title, Description, Status from SR_room"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)) { if ($row[3] == '1'){$rstatus = 'Enabled';} else {$rstatus = 'Disabled';} print << END; } ?>

	Add	Room No.	Title	Description	Status
Edit	Delete	$row[0]	$row[1]	$row[2]	$rstatus