Page 1 of 1

Search multiple columns...

Posted: Wed Jul 06, 2011 1:17 pm
by Sagar_999
I want to search record in multiple fields(Like Name, Number,Email)... When I put any search string in textbox result should be displayed (Display all that records which is satisfying search term.) . I had tried folowing script but it won't work... can anybody help...

$str=$_GET['s'];
$sql = "SELECT * FROM login WHERE name LIKE '%$str%' ¦¦ Number LIKE '%str%' ¦¦ Email LIKE '%$str%'";
$res = mysql_query($sql, $link) or die($sql);

Hope for positive reply asap...
Sagar...

Re: Search multiple columns...

Posted: Wed Jul 06, 2011 1:22 pm
by Jade
You're missing a $ in front of the second str in your query.

Code: Select all

$str=$_GET['s'];
$sql = "SELECT * FROM login WHERE name LIKE '%$str%' ¦¦ Number LIKE '%$str%' ¦¦ Email LIKE '%$str%'";
$res = mysql_query($sql, $link) or die($sql);

while($row= mysql_fetch_assoc($res))
   var_dump($row);
 

Re: Search multiple columns...

Posted: Thu Jul 07, 2011 10:51 am
by Sagar_999
Hey Thanks Buddy for reply