I am having an issue where my page throws a "No database selected" error when I am logged on but it works fine when I am NOT logged on. Here is my code:
$cat = $_GET['cat'];
// IF NOT LOGGED ON -- ONLY ALLOW PUBLIC CATS TO BE SELECTED!!
if ($_SESSION['logged'] != 'on') {
$sql = sprintf("SELECT * FROM diningcategories WHERE publish='1' AND catName='%s'",
mysqli_real_escape_string($spositas, $cat));
}
// IF LOGGED ON ALLOW UNPUBLISHED CATEGORIES TO BE SELECTED
else {
$sql = sprintf("SELECT * FROM diningcategories WHERE catName='%s'",
mysqli_real_escape_string($spositas, $cat));
}
mysqli_select_db($spositas, 'spositas_db');
$selectCat = mysqli_query($spositas, $sql) or die(mysqli_error($spositas));
$selectedCat = mysqli_fetch_assoc($selectCat);
// IF NOT LOGGED ON SELECT PUBLIC MENU ITEMS BASED ON CATEGORY
if ($_SESSION['logged'] != 'on') {
$sql = sprintf("SELECT * FROM diningmenu WHERE displayOnMenu='1' AND Category='%s'",
mysqli_real_escape_string($spositas, $cat));
}
// IF LOGGED ON ALLOW ALL MENU ITMES TO BE DISPLAYED
else {
$sql = sprintf("SELECT * FROM diningmenu WHERE Category='%s'",
mysqli_real_escape_string($spositas, $cat));
}
mysqli_select_db($spositas, 'spositas_db');
$selectMenuItems = mysqli_query($spositas, $sql) or die(mysqli_error($spositas));
$menuItems = mysqli_fetch_assoc($selectMenuItems);
I have searched and browsed many questions that are similar to mine but I'm having a hard time solving my issue.