Hi

I have 2 multi list selection boxes which users can select options from one and add them to the right selection box or remove them from the right selection box. Once they hit submit the selected info goes to mysql database where its stored. Then the selections they have made stay in the right box, which is what I want to happen, until the page is refreshed, then the box is empty. Even though they are still in the mysql database. I will past all the relevant code below.

<form action="ptmemberaccount.php" method="post" enctype="multipart/form-data"onsubmit="multipleSelectOnSubmit()">
<table width="500" align="left">
<tr>
<td width="500" height="300" align="center">
<select multiple name="fromBox[]" id="fromBox">

<?php

foreach($fromPool as $itm){

echo "\t" . '<option value="' . $itm . '">' . $itm . '</option>' . PHP_EOL;

}

?>

</select>
<select multiple name="venue[]" id="toBox">

<?php

foreach($toPool as $itm){

echo "\t" . '<option value="' . $itm . '">' . $itm . '</option>';

}

?>

</select> </td>
</tr>
<tr>
<td align="center" height="35"><script type="text/javascript">

createMovableOptions("fromBox","toBox",400,200,'Tr aining Venues','Selected Training Venues');

</script>

<p>Use the buttons to Add/Remove selections</p></td></td>
</tr>
<tr>
<td align="center" height="100">
<input name="updateBtn4" type="submit" id="updateBtn4" value="Update" />
<input name="parse_var" type="hidden" value="venue" />
<input name="thisWipit" type="hidden" value="<?php echo $thisRandNum; ?>" />

</tr>
</table>
</form>

PHP ///////

// ------- PARSING VENUE ---------
if ($_POST['parse_var'] == "venue"){


$venue = $_POST['venue'];

// Update the database data now here for all fields posted in the form
$sqlUpdate = mysql_query("UPDATE ptdata SET venue='$venue' WHERE id='$id' LIMIT 1");
if ($sqlUpdate){
$success_msg = '<img src="images/Form/round_success.png" width="20" height="20" alt="Success" />Your venue information has been updated successfully';
} else {
$error_msg = '<img src="images/Form/round_error.png" width="20" height="20" alt="Failure" /> ERROR: Problems arose during the information exchange, please try again later</font>';
}
}
// ------- END PARSING VENUE ---------


<?php

////////// Venue Array PHP For Multi Selection Boxes ////////////

$dbString = ' '; // To be pulled from Database

$toPool = explode(',', $dbString);

$pool = Array('Your Home','My Home','Outside','Private Studio','Your Work','Gym');

if($_SERVER['REQUEST_METHOD'] == 'POST'){

$toPool = (count($_POST['venue']) > 0)? $_POST['venue'] : Array();

$newDbString = implode(',', $toPool); // Store in Database;


}

$fromPool = array_diff($pool, $toPool);

?>

Haven't got enough room for the javascript, but I don't think thats the problem really