Re: Re: set array

At 11:08 PM 11/25/2013, John Taylor-Johnston wrote:

I have a SET field in MYSQL.

'1. Type One','2. Type Two','3. Type Three' The user can multi-select <select name="DPRtype[]" multiple> <option value="1. Type One"> <option value="2. Type Two"> <option value="3. Type Three"> </select> I just dont know how to express $_POST[DPRtype] to be able to build the $SQL to express the separate possibilities. $sql = "UPDATE taylorjo.CRTP_CGA SET DPRtype = '$_POST[DPRtype]' ";

If I use a foreach like this, it will be very clunky. And I'll have an extra comma at the end. What is a cleaner way? $MyString = express_value_select ($_POST['DPRtype'],"1. Type One"); $MyString .= express_value_select ($_POST['DPRtype'],"2. Type Two"); $MyString .= express_value_select ($_POST['DPRtype'],"3. Type Three"); function express_value_select($tofilter,$tofind) { foreach($tofilter as $value){

      if ($value == $tofind) echo $tofind.",";
    }

}

You don't want to use "echo" in a function, you want to return the value. Store the values returned in a temporary array, then implode the array to get the comma separated string <?php function express_value_select($tofilter,$tofind) { foreach($tofilter as $value){

      if ($value == $tofind) return $tofind;
    }

} $tmp = array(); $tmp[] = express_value_select ($_POST['DPRtype'],"1. Type One"); $tmp[] = express_value_select ($_POST['DPRtype'],"2. Type Two"); $tmp[] = express_value_select ($_POST['DPRtype'],"3. Type Three"); $MyString = implode(", ",$tmp); ?> Ken