RE: [PHP] OK SQL experts...
| From: | Jay Blanchard | Date: | Fri, 23 Apr 2004 15:55:36 +0000 |
| Subject: | RE: [PHP] OK SQL experts... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-184417@lists.php.net to get a copy of this message | ||
[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 LIKE '%" . $keyword .
"%')
AND
status = 'active'";
The single quoted variables do not get parsed