Insert Multiple values into column
I have a standard select multiple form element that is supposed to insert multiple values into a table like this. Only problem is that it is only saving one value. Database column is an INT with a length of 12 so there should be plenty of room to save multiple values? How do I do this?
<select name="contrID" size="3" multiple="multiple" id="contrID">
<?php
do {
?>
<option value="<?php echo $row_Contractors['userID']?>"><?php echo $row_Contractors['fname']?></option>
<?php
} while ($row_Contractors = mysql_fetch_assoc($Contractors));
$rows = mysql_num_rows($Contractors);
if($rows > 0) {
mysql_data_seek($Contractors, 0);
$row_Contractors = mysql_fetch_assoc($Contractors);
}
?>
</select>