Re: [PHP] Database error: Invalid SQL:

2007-05-24 Thread Richard Lynch
On Wed, May 23, 2007 11:42 pm, 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_da

Re: [PHP] Database error: Invalid SQL:

2007-05-23 Thread Christian Haensel
ot; <[EMAIL PROTECTED]> Cc: 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_star

Re: [PHP] Database error: Invalid SQL:

2007-05-23 Thread Chris
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

[PHP] Database error: Invalid SQL:

2007-05-23 Thread wisuttorn
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.c

RE: [PHP] Database Error

2002-03-08 Thread Robert V. Zwink
ry"); return $ret; } Robert Zwink http://www.zwink.net -Original Message- From: Navid Yar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 4:59 PM To: 'Robert V. Zwink' Subject: RE: [PHP] Database Error I just tried that Robert. It still gives me the same error that it

RE: [PHP] Database Error

2002-03-07 Thread Navid Yar
hecked the syntax on the MySQL command line and it worked just fine. So it's not the syntax either. I don't know what it could be :( -Original Message- From: Robert V. Zwink [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:42 PM To: Navid Yar Subject: RE: [PHP] Databas

RE: [PHP] Database Error

2002-03-07 Thread Navid Yar
Yes, Jason. I posted it earlier, but here it is again. // Error I'm getting Error in query: SELECT label FROM menu WHERE id = 3 Warning: Supplied argument is not a valid MySQL result resource in e:\localhost\menu\menu.class.php on line 47 // Object being called from get.php get_label(1); ?>

RE: [PHP] Database Error

2002-03-07 Thread Navid Yar
, 2002 4:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Database Error On Wednesday 06 March 2002 18:27, Navid Yar wrote: > I'm thinking that it probably has to do with the quoting scheme or > something else. I tried it on the command line, and it worked fine. I > don't even th

Re: [PHP] Database Error

2002-03-07 Thread Jason Wong
On Wednesday 06 March 2002 18:27, Navid Yar wrote: > I'm thinking that it probably has to do with the quoting scheme or > something else. I tried it on the command line, and it worked fine. I > don't even think it matters what types of quotes I use around the id > field. I tried both (single and d

RE: [PHP] Database Error

2002-03-07 Thread Navid Yar
--- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:51 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Database Error On Wednesday 06 March 2002 17:56, Navid Yar wrote: > Ok guys, I need help with this one. I am getting the error: Error in > query: SELECT label FROM m

Re: [PHP] Database Error

2002-03-07 Thread Jason Wong
On Wednesday 06 March 2002 17:56, Navid Yar wrote: > Ok guys, I need help with this one. I am getting the error: Error in > query: SELECT label FROM menu WHERE id = '1'. Why am I getting this > error? It seems right to me. I have the following code to call the class > object, and I listed the clas

[PHP] Database Error

2002-03-07 Thread Navid Yar
Ok guys, I need help with this one. I am getting the error: Error in query: SELECT label FROM menu WHERE id = '1'. Why am I getting this error? It seems right to me. I have the following code to call the class object, and I listed the class below it (I'm fairly new to classes): // Object being c