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...
Search multiple columns...
Moderator: General Moderators
Re: Search multiple columns...
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...
Hey Thanks Buddy for reply