Search multiple columns...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Sagar_999
Forum Newbie
Posts: 7
Joined: Tue Jun 28, 2011 11:36 pm

Search multiple columns...

Post 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...
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Re: Search multiple columns...

Post 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);
 
Sagar_999
Forum Newbie
Posts: 7
Joined: Tue Jun 28, 2011 11:36 pm

Re: Search multiple columns...

Post by Sagar_999 »

Hey Thanks Buddy for reply
Post Reply