function api_getMembers($house, $date = 'now()') { _api_getMembers_output('select * from member where house=' . mysql_escape_string($house) . ' AND entered_house <= date('.$date.') and date('.$date.') <= left_house'); }
function api_getMembers($house, $date = 'now()') { # $date may be a function such as now(), the default, and so cannot be used # as a parameter. _api_getMembers_output("SELECT * FROM member, person_names p\n WHERE house = :house\n AND member.person_id = p.person_id AND p.type = 'name'\n AND p.start_date <= date({$date}) and date({$date}) <= p.end_date\n AND entered_house <= date({$date})\n AND date({$date}) <= left_house", array(':house' => $house)); }