Multicheckbox List Store in Single DB and Search

  
  
  
function ProjectCheckboxModify($Actions){   
global $DBaditya_properties;  
  
	if($Actions == "Update")  
	{  
			$checkboxlist = '*'.implode('*',$_REQUEST['AmenitiesList']).'*';  
  
		for($c = 0; $c < sizeof($checkboxlist); $c++)   
		{  
        $query = "UPDATE properties SET amenities = '".$checkboxlist ."' WHERE property_id=".CCGetFromGet("property_id");  
		//$DBaditya_properties->query($query);  
        $result = mysql_query($query) or die(mysql_error());  
	    }  
					  
	}else if($Actions == "Insert")  
	{  
  
		$checkboxlist = '*'.implode('*',$_REQUEST['AmenitiesList']).'*';  
		for($c = 0; $c < sizeof($checkboxlist); $c++)   
		{  
        $query = "UPDATE properties SET amenities = '".$checkboxlist ."' WHERE property_id=".mysql_insert_id();  
		//$DBaditya_properties->query($query);  
        $result = mysql_query($query) or die(mysql_error());  
	    }  
	}  
  
}  
  

  
  
if(CCGetParam("s_MutiCheckBoxControl,"")){ // Check to see if the multi check box was sent as part of the search  
  
$SearchValue=CCGetParam("s_MutiCheckBoxControl,"");  
$DBField = "FieldInDBtoSearch"; // Your tables field name that has your multi checkbox data in it.  
$Delim = "*"; //The delimiter your are using to store multi checks in your DB (I usually use ~~ as the DB delimiter so most any char can be in the CB Text).  
$Connector=" AND "; //Use if occurrence of all checked items are to be found eg: exact match  
//$Connector=" OR "; //Use if any checked item causes a match  
  
$TSQL=$Component->ds->Where; //Get the existing Where Clause  
 if($TSQL){ $TSQL .= " AND ";} // The Connector if a Where clause already exists  
$TSQL .="(";  
  
$ArrayNum=count($SearchValue);  
$i=1;  
while($i<$ArrayNum){  
$TQSL .=' INSTR("'.$Delim.$SearchValue[$i-1].$Delim.'" , '.$DBField.') > 0 '.$Connector;  
$i++;  
}  
  
$TQSL .=' INSTR("'.$Delim.$SearchValue[$i-1].$Delim.'" , '.$DBField.') > 0 ';  
$TSQL .=")";  
$Component->ds->Where=$TSQL;  
  
//echo "NEW SQL WHERE STMT: ".$TSQL."  --END SQL ".$test; die(); //Remove after $TSQL looks Valid  
  
}  
  

  
 $Temp =  CCGetParam("MultiControlName","");  
 //echo $Temp." ".$Temp[0]." ".$$Temp[1];  
  
$Delim="~~";  
  
 if($Temp[0]==""){$Component->Errors->addError("Required Value Error Text");return true;} // This Code if it is a required field.  
 if($Temp)  
{  
 $DBValue = implode($Delim,$Temp);  
  
$DBValue=$Delim.$DBValue.$Delim;  
 	  
 $Container->MultiControlName->SetValue($DBValue);  
 }