Hi,
How do I change the query below to search in two fields instead of just one? For example, I want the query to search two fields: job_id and jobtype - instead of just job_id.

$query = "SELECT lastname, firstname, state, zip, jobtype, otherjobtype, nightavail, weekendavail, ptft, resume FROM data WHERE job_id LIKE '%" . $trimmed . "%'
 ORDER BY lastname ";

:yawn:

$query = "SELECT lastname, firstname, state, zip, jobtype, otherjobtype, nightavail, weekendavail, ptft, resume FROM data 
				WHERE (job_id LIKE '%" . $trimmed . "%') OR (jobtype LIKE '%" . $trimmed . "%')
 ORDER BY lastname ";