[PHP] MySQL joins

[Alexander P. Javier]

why do i get errors on MySQL queries that have joins?

 alyx 



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

[PHP] MySQL joins

[Alexander P. Javier]

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 
H =(


 alyx 



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

[PHP] Newbie on Sessions/Pages Management

[Alexander P. Javier]

I'm very new to PHP, as a matter of fact, I never had any experience anything about 
web-enabled applications development. I've been more into local Visual Basic and MS 
SQL Serve devt.  If there's any kind soul out there, please HLP

The question is: why do the values of my session variables disappear when i traverse 
through different php scripts? duhh  =(


Sincerely yours,
Alex



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

[PHP] sessions

[Alexander P. Javier]

ok, i got i working now, thanx to all who helped especially michael, chris  edward

 alyx 



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