Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at end of input at character 2014 in /home/gofindco/public_html/event/website/search130109.php on line 107
Problem with query SELECT DISTINCT even.code as even_code ,even.name ,even.website_url ,even.email ,even.phone_no ,even.fax_no ,even.cell_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 ,edat.start_date as orig_start_date ,TO_DATE(REPLACE('', 'ALL', edat.start_date), 'YYYY-MM-DD') as orig_from_date ,edat.start_date as order_date ,TO_CHAR(edat.start_date , 'FMDDth FMMonth YYYY') as start_date ,TO_CHAR(edat.end_date , 'FMDDth FMMonth YYYY') as end_date ,TO_CHAR(TO_DATE(REPLACE('', 'ALL', edat.start_date), 'YYYY-MM-DD'), 'FMDDth FMMonth YYYY') as from_date_fm ,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'), 'FMDDth FMMonth YYYY') as today_date ,clnt.company_name as ticket_company ,clnt.url as web_url FROM events even LEFT OUTER JOIN clients clnt ON (even.clnt_code = clnt.code) ,event_menus emnu ,event_dates edat WHERE even.code = emnu.even_code AND edat.even_code = even.code AND even.xbat_code = REPLACE('', 'ALL', even.xbat_code) AND emnu.xmnu_code = REPLACE('', 'ALL', LOWER(emnu.xmnu_code)) AND edat.start_date <= TO_DATE(REPLACE('', 'ALL', edat.start_date), 'YYYY-MM-DD') -- OR edat.start_date >= TO_DATE(REPLACE('', 'ALL', edat.start_date), 'YYYY-MM-DD') ) AND edat.end_date >= TO_DATE(REPLACE('', 'ALL', edat.end_date), 'YYYY-MM-DD') AND even.status = 'A' AND edat.status = 'A' AND emnu.status = 'A' AND emnu.bsns_code = 'even0000' AND even.bsns_code = 'even0000' ORDER BY edat.start_date LIMIT 5 OFFSET contact support on 0861 GO FIND.
ERROR: syntax error at end of input at character 2014