Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "AND" at character 1701 in /home/gofindco/public_html/event/website/link091109.php on line 156
Problem with query SELECT even.code ,even.name ,even.website_url ,even.email ,even.fax_no ,TRIM(even.contact) as contact ,TRIM(even.cell_no) as cell_no ,TRIM(even.phone_no) as phone_no ,even.address ,even.how_much ,even.description ,even.useful_info ,even.image ,xmnu.image as xmnu_image ,TO_CHAR(edat.start_date , 'DD Month Day') as start_date ,TO_CHAR(edat.end_date , 'DD Month Day') as end_date ,TO_CHAR(edat.start_date , 'DD Month YYYY') as new_start_date ,TO_CHAR(edat.end_date , 'DD Month YYYY') as new_end_date ,TO_CHAR(edat.start_date , 'yyyymmdd') as check_date ,to_char(date_trunc('second', current_timestamp + interval '7 hour'), 'yyyymmdd') as creation_date ,to_char(date_trunc('second', current_timestamp + interval '7 hour'), 'DD Month Day') as today_date ,clnt.company_name as ticket_company ,clnt.url as web_url ,even.code as even_code ,even.addr_line1 ,even.addr_line2 ,even.addr_line3 ,even.city ,even.postal_code ,even.state ,even.country ,initcap(replace(replace(xmnu.name, ' ', ''), '
', ' ')) as alt_tag ,even.latitude_1 ,even.latitude_2 ,even.latitude_3 ,even.longitude_1 ,even.longitude_2 ,even.longitude_3 ,even.contact_event ,even.attendance ,even.organizer_phone ,even.organizer_email FROM events even LEFT OUTER JOIN clients clnt ON (even.clnt_code = clnt.code) ,event_menus emnu ,menu_types xmnu ,event_dates edat WHERE emnu.xmnu_code = AND even.code = emnu.even_code AND edat.even_code = even.code AND xmnu.code = emnu.xmnu_code AND even.status = 'A' AND edat.status = 'A' AND emnu.status = 'A' ORDER BY edat.start_date LIMIT 5 OFFSET contact support on 0861 GO FIND.
ERROR: syntax error at or near "AND" at character 1701