Still learning SQL. Why would the following give PHP Notice: Undefined variable:
# see if room already exists
$queryRoom = "
SELECT NVL(COUNT(*),0) AS ROOM
WHERE room = '" . $_SESSION['room'] . "'
$room = ociparse($connect, $queryRoom);
$roomMatch = ociresult($room, "ROOM");
if ( $roomMatch > 0 ) # found existing room name
$roomNum = ociresult($room,"ROOM_NUM");
echo "<br>room_num of match: " . $roomNum;