> -----Original Message-----
> From: Robbie Staufer [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 04, 2003 3:59 PM
> Subject: [PHP-DB] variable within regular expression
> I have a php query form in which the user input must be converted to a
> regular expression before querying the db.  Something like this
> pseudo code:
>          $var = $_GET['usr-input'];
>          $var = '%$var%';
> SELECT * FROM table WHERE field LIKE $var.
> I can't find the right syntax to make this work.  Does anyone know?

I think maybe the single quotes don't interpolate the value of the variable.

In other words, let's say $var is 'fubar':

$var = '%$var%'; // -> is literally %$var%


$var = "%$var%"; // -> is %fubar%

Anyway, here's some of my code that is similar to (what I think) you're
trying to do:

if (isset($_GET['nstring'])) {
    $nstring = addslashes($_GET['nstring']);
    $squery = "SELECT * FROM lead
               WHERE name LIKE '%{$nstring}%'
               ORDER BY source, ref_by, date DESC";
    $sresult = mysql_query($squery);
} // etc...

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to