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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
