search

[jeff5656]

Here's how a user can search for something in ONE field (mrn).  How do write it so the record is retrieved if the search term occurs in ANY field in the record? So if "jeff" occurs anywhere, pull that record.

 

$query = "SELECT * ".
	"FROM icu WHERE mrn = '" . $_POST['mrn'] . "' ".
	"ORDER BY rcf_date2 ";
$results = mysql_query ($query) or die (mysql_error());

[sklein99]

The most straightforward way is to simply check each field explicitly:

 

$query = "SELECT * FROM icu ".

      "WHERE mrn = '" . $_POST['mrn'] . "' ".

      "OR field2 = '" . $_POST['mrn'] . "' ".

      "OR field3 = '" . $_POST['mrn'] . "' ".

...

      "ORDER BY rcf_date2 ";

 

Also, you may want to use "LIKE" to get partial matches, like so:

 

$query = "SELECT * FROM icu ".

      "WHERE mrn LIKE '%" . $_POST['mrn'] . "%' ".

      "OR field2 LIKE '%" . $_POST['mrn'] . "%' ".

      "OR field3 LIKE '%" . $_POST['mrn'] . "%' ".

...

      "ORDER BY rcf_date2 ";

 

... to match field data such as "Jeff5656" with search term "jeff".