comparing checked values to record fields

[glennn.php]

	$checkbox1 = $_POST['specialty']; 
	$string1 = '*'.@implode('*',$checkbox1).'*';

	$checkbox2 = $_POST['subspecialty']; 
	$string2 = '*'.@implode('*',$checkbox2).'*';
	echo $string2;
	// }


$sql="SELECT * FROM $tbl_user WHERE specialty LIKE '%$string1%' OR subspecialty LIKE '%$string2%' ORDER BY contact_name ASC";

 

the values in the fields being searched are *Pulmonary Pathology*Renal Pathology* and *Chemical Pathology*Hematopathology* (for instance...)

 

if i search JUST Pulmonary Pathology or JUST Hematopathology i get my results, but if i search with terms that are NOT in there (Molecular Diagnostics) I get NO results.

 

Can someone show me how to get ANY of the data that's in said fields... PLEASE? i've been on this all day...

 

Thanks

GN

[poleposters]

Hey I have a hunch that it might be your WHERE syntax.

 

Can you clarify your question.Its a little hard to understand