예제 #1
0
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');
}
예제 #2
0
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));
}