  <script type='text/javascript' >

function popup(event_code)

{

window.open("popup.php?event_code="+event_code, "_blank","toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=yes, width=250, height=200, left=200, top=62")

}

</script>


   <br />
<b>Warning</b>:  pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  syntax error at end of input at character 3407 in <b>/home/gofindco/public_html/event/website/search_261109.php</b> on line <b>421</b><br />
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

				   ,edat.start_time as start_time

				   ,edat.end_time as end_time

		           ,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(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

				   ,even.code as even_code

				   ,vnus.name as vnus_name

				    ,COALESCE(vnus.addr1, even.addr_line1, even.address) as addr_line1

				 	,COALESCE(vnus.addr2, even.addr_line2) as addr_line2

				 	,COALESCE(vnus.addr3, even.addr_line3) as addr_line3,COALESCE(vnus.city, even.city) as city 

				 	,COALESCE(vnus.postalcode, even.postal_code) as postal_code

				   ,COALESCE(vnus.stateprovince, even.state) as state 

				   ,COALESCE(vnus.country, even.country) as country 

		            ,COALESCE(vnus.latitude, even.latitude_1||'&deg;&nbsp;'||even.latitude_2||'.'||even.latitude_3) as latitude_1  

 	        	 ,COALESCE(vnus.longitude, even.latitude_1||'&deg;&nbsp;'||even.latitude_2||'.'||even.latitude_3) as longitude_1   								  				  ,even.contact_event

				   ,even.currency

				   ,even.attendance

				    ,even.organizer_phone

				   ,even.organizer_email

				   ,even.booking_company as booking_company

				   ,even.booking_url as booking_url

				   ,even.booking_fax as booking_fax

				   ,even.booking_cell as booking_cell		

				  ,even.organizer_company  as organizer_company	

				  ,even.price_info  as price_info		

				  ,even.free  as free		

				  ,even.upload					   				  		  				  	   			   

			FROM  events even LEFT OUTER JOIN clients clnt ON (even.clnt_code = clnt.code)

			LEFT OUTER JOIN venues vnus ON (even.vnus_code = vnus.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) OR even.xbat_code1 = REPLACE('', 'ALL', even.xbat_code1))

            AND emnu.xmnu_code = REPLACE('', 'ALL', LOWER(emnu.xmnu_code))

            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.<br/>ERROR:  syntax error at end of input at character 3407