//include("admin/tool_room_status.php");
// Get tool room status (include will not work)
// Connecting, selecting database
$dbconn = mysql_connect('aeaclubs.ipowermysql.com', 'clubtool_php', 'php') or die('Could not connect: ' . mysql_error());
mysql_select_db('clubtool_cc_db') or die('Could not select database');
// Performing SQL query
$query = "SELECT * FROM toolroom";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// Make sure result is unique
$num = mysql_numrows($result);
if ($num != 1){
echo "Error, result not unique or no result found
Number of results: $num
";
echo $query;
}
// Get results from query
$row = mysql_fetch_assoc($result);
$room_status = $row["status"];
$date_stamp = $row["date"];
$banner = $row["banner"];
// Free resultset
//mysql_free_result($result);
// Closing connection
mysql_close($dbconn);
?>
The tool room is normally open Tuesdays and Thursdays from 11:30 - 12:15. Members may refer to the "Tool Status" page below to see if a tool is available