Military Child Care

Data Entry

Data Entry: On-Site Visit / TA Log for Centers and Providers

Please select a center or provider:

(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, datemodified FROM provider as p WHERE 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, datemodified FROM centers as c WHERE 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