So do I have to have multiple menu/list fields? Can't I have one and repeat the option. I have tried to do this but it doesn't insert work correctly. I inserted a record but the fields were blank.
<select name="Week" size="5" multiple="multiple" id="Week">
<?php
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_Week){
?><?php
do {
?>
<option value="<?php echo $row_Week['Week']?>"><?php echo $row_Week['Week']?></option>
<?php
} while ($row_Week = mysql_fetch_assoc($Week));
$rows = mysql_num_rows($Week);
if($rows > 0) {
mysql_data_seek($Week, 0);
$row_Week = mysql_fetch_assoc($Week);
}
?>
<?php
} // RepeatSelectionCounter_1 Begin Alternate Content
else{
?>
<?php } // RepeatSelectionCounter_1 End Alternate Content
if(!$RepeatSelectionCounterBasedLooping_1 && $RepeatSelectionCounter_1_IterationsRemaining != 0){
if(!$row_Week && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_Week = mysql_fetch_assoc($Week);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?></select>