Usually you need to specify the type: inner join, left join, right join, straight join etc.
<OT>That sounds like the good old times when we did air-to-air refueling :oP </OT>
Sorry, had to :P
----- Original Message ----- From: "Chris" <dmagick@gmail.com>
To: "wisuttorn" <d173ee@hotmail.com>
Cc: <php-general@lists.php.net>
Sent: Thursday, May 24, 2007 7:34 AM
Subject: Re: [PHP] Database error: Invalid SQL:
wisuttorn wrote:
I have a problem please help me
when i loged in to egroup this show "
Database error: Invalid SQL: SELECT DISTINCT
egw_cal_repeats.*,egw_cal.*,cal_start,cal_end,cal_recur_date FROM egw_cal
JOIN egw_cal_dates ON egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user
ON egw_cal.cal_id=egw_cal_user.cal_id LEFT JOIN egw_cal_repeats ON
egw_cal.cal_id=egw_cal_repeats.cal_id WHERE (cal_user_type='u' AND
cal_user_id IN (6,-1)) AND cal_status != 'R' AND 1179939600 < cal_end AND
cal_start < 1180025999 AND (recur_type IS NULL AND cal_recur_date=0 OR
cal_recur_date=cal_start) ORDER BY cal_start
mysql Error: 1064 (You have an error in your SQL syntax near 'ON
egw_cal.cal_id=egw_cal_dates.cal_id JOIN egw_cal_user ON
egw_cal.cal_id=egw_c' at line 1)
I guess that whatever database you are using doesn't allow 'JOIN' as a join type.
Usually you need to specify the type: inner join, left join, right join, straight join etc.
Ask your specific database list about it.
-- Postgresql & php tutorials
http://www.designmagick.com/
-- PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php