the query is:

select appointment.*, date_format(appointment.startdatetime,'%m-%d-%Y') as yrappt from 
appointment left join guest on appointment.appointment_id = guest.appointment_id

i think it's syntactically correct, it returns the correct rows when run with the 
mysql.exe program but gets an error when run thru my php code in a browser.

by the way, i use apache-php-mysql for windows. and i program locally.  please 


Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games

Reply via email to