MySQL joins
| From: | Alexander P. Javier | Date: | Mon, 25 Feb 2002 23:40:47 +0000 |
| Subject: | MySQL joins | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86172@lists.php.net to get a copy of this message | ||
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