Re: [PHP] OK SQL experts...

The parenthesis are OK. The query might take a long time to run with 3 LIKE statements. >>Backticks, single quotes, or nothing at all makes no difference. I >>believe the parsing error is due to my parentheses or AND/OR structure. >>Any thoughts on that? >> >> >> >>On Apr 23, 2004, at 8:32 A

Re: [PHP] OK SQL experts...

I think you want to remove the single quotes around the field names. SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%' OR field_2 LIKE '%$keyword%' OR field_3 LIKE '%$keyword%') AND status = 'active'; >>I STFW and RTFM and I still can't figure out why this returns a 1064 >>parse error:

Re: [PHP] OK SQL experts...

Brian Dunning wrote: On Apr 23, 2004, at 10:13 AM, John Nichel wrote: Brian Dunning wrote: I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%')

Re: [PHP] OK SQL experts...

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''my_table' WHERE ('field_1' LIKE '%%' OR 'field2' Because you are using a single quotes around your table/field names. Remove them or use ` (back tick). As sugges

Re: [PHP] OK SQL experts...

From: "Brian Dunning" <[EMAIL PROTECTED]> > My error. Here is the actual return: > > You have an error in your SQL syntax. Check the manual that corresponds > to your MySQL server version for the right syntax to use near > ''my_table' WHERE ('field_1' LIKE '%custom%' OR 'field_ > > I am searching f

Re: [PHP] OK SQL experts...

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''my_table' WHERE ('field_1' LIKE '%%' OR 'field2' Because you are using a single quotes around your table/field names. Remove them or use ` (back tick). As sugges

Re: [PHP] OK SQL experts...

* Thus wrote Brian Dunning ([EMAIL PROTECTED]): > > On Apr 23, 2004, at 10:13 AM, John Nichel wrote: > > >Brian Dunning wrote: > >>I STFW and RTFM and I still can't figure out why this returns a 1064 > >>parse error: > >>SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR > >>'field_

Re: [PHP] OK SQL experts...

On Apr 23, 2004, at 10:27 AM, Edward Peloke wrote: doesn't look like your $keyword value contains anything. My error. Here is the actual return: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''my_table' WHER

RE: [PHP] OK SQL experts...

doesn't look like your $keyword value contains anything. -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 1:19 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... On Apr 23, 2004, at 10:13 AM, John Nichel wrote: > Brian

Re: [PHP] OK SQL experts...

On Apr 23, 2004, at 10:13 AM, John Nichel wrote: Brian Dunning wrote: I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'acti

Re: [PHP] OK SQL experts...

Brian Dunning wrote: I STFW and RTFM and I still can't figure out why this returns a 1064 parse error: SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; Anyone? TIA! - B1ff Lamer What does mysql_

Re: [PHP] OK SQL experts...

* Thus wrote Brian Dunning ([EMAIL PROTECTED]): > I STFW and RTFM and I still can't figure out why this returns a 1064 > parse error: > > SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR > 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND > 'status' = 'active'; You

Re: [PHP] OK SQL experts...

How are you manipulating the whole SQL string?? $sql = "SELECT..."; ??? or $sql = 'SELECT...'; ??? In this case you will have to use double quotes because PHP won't parse single quote strings for searching embedded PHP variables. May be this is the problem. -William El vie, 23-04-2004 a

Re: [PHP] OK SQL experts...

if that works move up into: SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%') AND status = 'active'; Yes, I actually did exactly that. Everything works until I have more than one statement inside the (x LIKE x OR x LIKE x) parens. That's why I figured there has to be something wrong with m

RE: [PHP] OK SQL experts...

[snip] SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%') AND status = 'active'; if that works continue until you get an error. [/snip] That'll give you an error right there. That old single quoted variable will get you every time. :) WHERE (field_1 LIKE '%$keyword%') WHERE (field_1 LIKE

RE: [PHP] OK SQL experts...

Brian Dunning on Friday, April 23, 2004 8:19 AM said: > SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR > 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND > 'status' = 'active'; have you tried simply: SELECT * FROM my_table WHERE statu

Re: [PHP] OK SQL experts...

ng put in the $keyword variable? You are sure all these columns exist? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no di

RE: [PHP] OK SQL experts...

[snip] SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; [/snip] *slaps forehead* "SELECT * FROM my_table WHERE (field_1 LIKE '%" . $keyword . "%' OR field_2 LIKE '%" . $keyword . "%' OR field_3 L

RE: [PHP] OK SQL experts...

>>> I STFW and RTFM and I still can't figure out why this returns a 1064 >>> parse error: >>> >>> SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR >>> 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND >>> 'status' = 'active'; Why don't you try rebuilding the query. I

Re: [PHP] OK SQL experts...

> these > > columns exist? > > > > -Original Message- > > From: Brian Dunning [mailto:[EMAIL PROTECTED] > > Sent: Friday, April 23, 2004 11:36 AM > > To: [EMAIL PROTECTED] > > Subject: Re: [PHP] OK SQL experts... > > > > > > Backticks,

Re: [PHP] OK SQL experts...

MAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no difference. I believe the parsing error is due to my parentheses or AND/OR structure. Any thoughts on that? On Apr 23, 2004, at 8:32 AM, John W. Holmes wrote: From: "Brian Dunning

Re: [PHP] OK SQL experts...

--Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no difference. I believe the parsing error is due to my parentheses or AND/OR stru

RE: [PHP] OK SQL experts...

if you echo out the query..what is the output? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing at all makes no difference. I believe

RE: [PHP] OK SQL experts...

what value is being put in the $keyword variable? You are sure all these columns exist? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:36 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... Backticks, single quotes, or nothing

RE: [PHP] OK SQL experts...

[snip] SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 'status' = 'active'; [/snip] How about this? SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%' OR field_2 LIKE '%$keyword%' OR field_3 LIKE '%$keyword%')

RE: [PHP] OK SQL experts...

the same error when I run it in phpmyadmin. > > > On Apr 23, 2004, at 8:34 AM, Edward Peloke wrote: > > > does it just return the error when running in the php page? If you > > pull it > > out can you run it in mysql without errors? > > > > -Original Message- > &g

Re: [PHP] OK SQL experts...

Backticks, single quotes, or nothing at all makes no difference. I believe the parsing error is due to my parentheses or AND/OR structure. Any thoughts on that? On Apr 23, 2004, at 8:32 AM, John W. Holmes wrote: From: "Brian Dunning" <[EMAIL PROTECTED]> I STFW and RTFM and I still can't figu

Re: [PHP] OK SQL experts...

From: "Brian Dunning" <[EMAIL PROTECTED]> > I STFW and RTFM and I still can't figure out why this returns a 1064 > parse error: > > SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR > 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND > 'status' = 'active'; Use backt

Re: [PHP] OK SQL experts...

AFAIK phpMyAdmin uses backticks for table/field names, not single quotes ... Friday, April 23, 2004, 5:22:35 PM, thus was written: > I tried it both ways - didn't make any difference (phpmyadmin adds the > single quotes when I was trying to use its sql function to debug, so I > figured what the h

Re: [PHP] OK SQL experts...

] Sent: Friday, April 23, 2004 11:23 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... I tried it both ways - didn't make any difference (phpmyadmin adds the single quotes when I was trying to use its sql function to debug, so I figured what the hell)... On Apr 23, 2004, at 8:

RE: [PHP] OK SQL experts...

does it just return the error when running in the php page? If you pull it out can you run it in mysql without errors? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:23 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] OK SQL experts... I

RE: [PHP] OK SQL experts...

[snip] I tried it both ways - didn't make any difference (phpmyadmin adds the single quotes when I was trying to use its sql function to debug, so I figured what the hell)... [/snip] Those aren't single quotes it adds to table and column names...those are back tics (on the same key as the tilde)

Re: [PHP] OK SQL experts...

I tried it both ways - didn't make any difference (phpmyadmin adds the single quotes when I was trying to use its sql function to debug, so I figured what the hell)... On Apr 23, 2004, at 8:27 AM, Edward Peloke wrote: why are the table and field names surrounded by single quotes? -Original

RE: [PHP] OK SQL experts...

why are the table and field names surrounded by single quotes? -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 11:19 AM To: [EMAIL PROTECTED] Subject: [PHP] OK SQL experts... I STFW and RTFM and I still can't figure out why this returns a 106