php mysql在同一个表中查找具有相同数据的多行

Question

Hi I've been searching for this now for a few days and can't seem to get it right, hoping someone might be able to lend a hand. Here is the scenario:

techinfo table

repid fname lname region
1234  bob   smith  NY
4567  bob   sacamano toronto
3478  bob   hill   texas
9876  bob   underwood vancouver
7345  tom   tucker  halifax
2357  bill  shatner  LA

I am trying to find all of the bobs based on the input field looking for repid, first name, last name, etc...

basiacally if somone types bob into the form it should return all info for all the bobs.

I am totally stuck on this.

i have gotten to the point of determining if there is a bob record and can pull one, but i can't pull multiples.

here are some of the code snippets for example. any help is greatly apprecaited.

$MetaQuery="SELECT * FROM `techinfo` WHERE repid='$_POST[repid]' OR fname='$_POST[fname]'";
$MetaResults=mysql_query($MetaQuery, $DBconnect);
if(mysql_num_rows($MetaResults)>0)
{   
/*
quick check of array storage
*/
 echo "<br>we found results:".$row['repid']. $row['fname']. $row['lname'];
 }

Answer 1

1) mysql_ functions are being depericated use PDO

2) please learn about sql injection

3 mysql_query returns a resource that has to be looped though eg.

while($row = mysql_fetch_assoc($MetaResults) {
    echo "<br>we found results:".$row['repid']. $row['fname']. $row['lname'];
}