Member Avatar for lwaterfo

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:

  • 2 Contributors
  • 1 Reply
  • 69 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by hielo
Member Avatar for hielo 
$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 ";
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.