ludjer

just add to your while loop a and expression $query = "SELECT CONCAT('',name,name2,name3,name4,name5,name6,name7,name8,name9,name10) as n FROM $usertable HAVING n LIKE '%$name%'"; $result = mysql_query($query) or DIE("Could not Execute Query on table $usertable"); $i = 0; if ($result) { print "Query successful on table $usertable<br><br>"; print "Your Query returned:<br>"; while ($row = mysql_fetch_array($result)&& $i != $maxrows) { $i++; print $row['n'] . "<br/>"; } }