bindparam on recordset not filtering as expected
<?php
$Existing_Rooms = new WA_MySQLi_RS("Existing_Rooms",$local_i,0);
$Existing_Rooms->setQuery("SELECT bridge_event_room.room_id FROM bridge_event_room LEFT JOIN 7_room ON bridge_event_room.room_id = 7_room.room_id WHERE bridge_event_room.event_id = ? GROUP BY 7_room.room_id");
$Existing_Rooms->bindParam("i", "".(isset($_GET['event'])?$_GET['event']:"") ."", "-1"); //WAQB_Param1
$Existing_Rooms->execute();
print_r($Existing_Rooms)
?>
<?php
$Church = new WA_MySQLi_RS("Church",$local_i,0);
$Church->setQuery("SELECT 2_department.church FROM 2_department LEFT OUTER JOIN 3_program ON 2_department.department_id = 3_program.department LEFT OUTER JOIN 4_calendar ON 3_program.program_id = 4_calendar.program WHERE 4_calendar.calendar_id = ?");
$Church->bindParam("i", "".(isset($_GET['calendar'])?$_GET['calendar']:"") ."", "-1"); //WAQB_Param1
$Church->execute();
?>
<?php
$Available_Rooms = new WA_MySQLi_RS("Available_Rooms",$local_i,0);
$Available_Rooms->setQuery("SELECT 7_room.* FROM 7_room LEFT OUTER JOIN bridge_event_room ON 7_room.room_id = bridge_event_room.room_id LEFT OUTER JOIN 6_event ON bridge_event_room.event_id = 6_event.event_id LEFT OUTER JOIN 5_event_category ON 6_event.event_category = 5_event_category.event_category_id LEFT OUTER JOIN 4_calendar ON 5_event_category.calendar = 4_calendar.calendar_id LEFT OUTER JOIN 3_program ON 4_calendar.program = 3_program.program_id LEFT OUTER JOIN 2_department ON 3_program.department = 2_department.department_id WHERE 2_department.church = ? AND 7_room.room_id != ? GROUP BY 7_room.room_id");
$Available_Rooms->bindParam("i", "".($Church->getColumnVal("church")) ."", "-1"); //WAQB_Param1
$Available_Rooms->bindParam("i", "".($Existing_Rooms->getColumnVal("room_id")) ."", "-1"); //WAQB_Param2
$Available_Rooms->execute();
print_r($Available_Rooms)
?>
$Existing_Rooms prints out:
[Results] => Array
(
[0] => Array
(
[room_id] => 1 This one was filtered out correctly
)
[1] => Array
(
[room_id] => 2
)
[2] => Array
(
[room_id] => 35
$Available_Rooms prints out
[Results] => Array
(
[0] => Array
(
[room_id] => 2 This should have been filtered out.
[room_value] => 80
[room_text] => Congo Room
[room_default_color] => #2C4217
)
[1] => Array
(
[room_id] => 3
[room_value] => 20
[room_text] => Baby Bay
[room_default_color] => #66CCCC
)
[2] => Array
(
[room_id] => 4
[room_value] => 30
[room_text] => Baby Reef
[room_default_color] => #4D5AB3
)
[3] => Array
(
[room_id] => 5
[room_value] => 50
[room_text] => Rainforest
[room_default_color] => #397D02
)
[4] => Array
(
[room_id] => 6
[room_value] => 90
[room_text] => Pipeline
[room_default_color] => #5c5c5c
)
[5] => Array
(
[room_id] => 7
[room_value] => 40
[room_text] => Toddler Grove
[room_default_color] => #4EBF85
)
[6] => Array
(
[room_id] => 8
[room_value] => 10
[room_text] => Welcome Hut
[room_default_color] => #98950b
)
[7] => Array
(
[room_id] => 10
[room_value] => 9
[room_text] => Floating
[room_default_color] => #8b95c3
)
[8] => Array
(
[room_id] => 33
[room_value] => 0
[room_text] => Administrative Help
[room_default_color] => #355E13
)
[9] => Array
(
[room_id] => 34
[room_value] => 0
[room_text] => test room
[room_default_color] => #355E13
)
[10] => Array
(
[room_id] => 35 This should have been filtered out.
[room_value] => 0
[room_text] => test room
[room_default_color] => #355E13
)
)
Seems like I did everything correctly, or did I miss something?
