Re: 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 las 11:02, Brian Dunning escribió: > > 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 my paren structure. When > I RTFM I saw someplace to use {}+ instead of () but it gave a different > error.