I am trying to fetch a value from one of my tables, however it doesn't appear to be retrieving it as when I echo the variable nothing is displayed.
Here is my code
<?php
$conn = new mysqli('localhost','root','root','neadatabase'); //Creating
connection to database
//Connection Error Checking
if ($conn->connect_error)
{
die("Connection Failed: " . $conn->connect_error);
}
echo ("Connection Successful");
//selecting bookings
$sqlSelectBookings = "
SELECT ActivID, DateRequired, TimeRequired
FROM activbooking
WHERE ActivID = '$_POST[ActivID]' AND DateRequired =
'$_POST[DateRequired]' AND '$_POST[DateRequired]' AND 'TimeRequired = '
$_POST[TimeRequired]'
";
$sqlSelectBookings = $conn->que($sqlSelectBookings);
//getting member limit
$sqlGetMemberLimit = "
SELECT memberLimit
FROM activity
WHERE activID = '$_POST[ActivID]'
";
$sqlGetMemberLimit = ($conn->query($sqlGetMemberLimit)-
>fetchObject(memberLimit));
echo $sqlGetMemberLimit;
Any ideas?
This is what happens when I run the page
Thanks