bootstrap multiple select update records

I m using following js: https://silviomoreto.github.io/bootstrap-select/methods/

Following is my code:

<select class="selectpicker" name="pendingdocs" multiple>
  <?php
do {  
?>
  <option value="<?php echo $row_PendingDocTypes['DocumentTypeID']?>"<?php if (!(strcmp($row_PendingDocTypes['DocumentTypeID'], $row_ApplicationDetails['AppDocPending']))) {echo "selected=\"selected\"";} ?>><?php echo $row_PendingDocTypes['DocumentTypeName']?></option>
  <?php
} while ($row_PendingDocTypes = mysql_fetch_assoc($PendingDocTypes));
  $rows = mysql_num_rows($PendingDocTypes);
  if($rows > 0) {
      mysql_data_seek($PendingDocTypes, 0);
	  $row_PendingDocTypes = mysql_fetch_assoc($PendingDocTypes);
  }
?>



</select>

I added single update record behaviour for the same. So this is a multi select dropdown option.

When i select multiple options & click update only 1 gets updated & multiple ain't getting updated.

If i select multiple options as: one, two, three; i want it to store as one, two, three

file also attached.

To allow multiple selections in php you need to name your form element: name="pendingdocs[]" (with the brackets).

That will pass the selected values as an array.

How did you want them inserted? Comma-separated? That would be done by updating line 167 to:
$WA_fieldValuesStr = "Y" . $WA_AB_Split . "".((isset($_POST["pendingdocs"]))?implode(", ",$_POST["pendingdocs"]):"") ."";

So it does update the data.. But i can't view it back on dropdown again.

I mean existing values aint displaying in dropdowns

You would have to use different code to re-select the values on the update page. What does the select list code look like on the update page currently?

<?php
do {
?>
<option value="<?php echo $row_PendingDocTypes['DocumentTypeName']?>"<?php if (!(strcmp($row_PendingDocTypes['DocumentTypeName'], $row_ApplicationDetails['AppDocPending']))) {echo "selected=\"selected\"";} ?>><?php echo $row_PendingDocTypes['DocumentTypeName']?></option>
<?php
} while ($row_PendingDocTypes = mysql_fetch_assoc($PendingDocTypes));
$rows = mysql_num_rows($PendingDocTypes);
if($rows > 0) {
mysql_data_seek($PendingDocTypes, 0);
$row_PendingDocTypes = mysql_fetch_assoc($PendingDocTypes);
}
?>

You could try:

<?php

do {

?>

<option value="<?php echo $row_PendingDocTypes['DocumentTypeName']?>"<?php if (strpos($row_ApplicationDetails['AppDocPending'], $row_PendingDocTypes['DocumentTypeName']) !== false) {echo "selected=\"selected\"";} ?>><?php echo $row_PendingDocTypes['DocumentTypeName']?></option>

<?php

} while ($row_PendingDocTypes = mysql_fetch_assoc($PendingDocTypes));

$rows = mysql_num_rows($PendingDocTypes);

if($rows > 0) {

mysql_data_seek($PendingDocTypes, 0);

$row_PendingDocTypes = mysql_fetch_assoc($PendingDocTypes);

}

?>

awesome.. thnks a lot