Military Child Care

Lists/Reports

List of Currently Enrolled Children

All active children from active providers in site

(select p.id as multi_id, 'provider' as multi_type, p.first_name, p.middle_name, p.last_name, p.first_name as name, p.zip as zipcode, p.city, p.state, p.active, datemodified FROM provider as p WHERE p.active = 'Y' and p.user_id = ) UNION (select c.id as multi_id, 'center' as multi_type, '' as first_name, '' as middle_name, '' as last_name, c.name, c.zipcode, c.city, c.state, c.active, datemodified FROM centers as c WHERE c.active = 'Y' and c.user_id = )
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') UNION (select c.id as multi_id, 'center' as multi_type, '' as first_name, '' at line 3