PHP MYSQL Form - Multiple Select List
Hi
I have a list in an insert form which I have set to multiple select. When more than one item in the list is selected, the results shows only the last item selected.
<select name="PropertyType" size="6" multiple="multiple" id="PropertyType">
<?php
do {
?>
<option value="<?php echo $row_rspropertyTypes['PropertyType']?>"><?php echo $row_rspropertyTypes['PropertyType']?></option>
<?php
} while ($row_rspropertyTypes = mysql_fetch_assoc($rspropertyTypes));
$rows = mysql_num_rows($rspropertyTypes);
if($rows > 0) {
mysql_data_seek($rspropertyTypes, 0);
$row_rspropertyTypes = mysql_fetch_assoc($rspropertyTypes);
}
?>
</select>
Any ideas?