Anyone know how to query multiple colums?

[Angeleyezz]

What I am trying to do is create a search box to search for a specific piece of information in my client database, say last name, or account number, invoice number, etc. is there a way i can use the keyword to match the query to multiple columns?

 

here is my code, the script works if i use the $query to select just 1 column. but how do i add other columns to match it to?

 

I know its  where "different columns" LIKE search  my problem is this line basically.

 

mysql_select_db("terra_elegante_operations", $con);



$searchfor = $_GET['search_term'];


$query = "select * from client_information where name_last like \"%$searchfor%\"";

$result = mysql_query($query) or die("Couldn't execute query");

$row = mysql_fetch_array($result);

echo $row['0'];

[bspace]

$query = "select * from client_information where concat(name_last,name_first,etc) like \"%$searchfor%\"";

 

check out "concat" and "concat_ws"

[Angeleyezz]

sweet it works, now i gotta figure out how to enclose the results in a while loop.  took me all afternoon to get this far lol.