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 HEEEELLLLPPPP!!!! =( alyx --------------------------------- Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games
