I am having trouble inserting selection from pull down menus in my form into mysql table. Whenever I select from pull down menu, the selection is not put into mysql...
Any feedback? I know I am doing something wrong.....


<?php

if ($submit): // A new business has been listed // using the form below.

$dbcnx = @mysql_connect("localhost", "removedforsecurity", "removedforsecurity");
mysql_select_db("removedforsecurity");

$sql = "INSERT INTO Business SET " .
"Business_Name='$businessname', " .
"Category='$category', " .
"Sub_Category='$subcategory', " .
"Neighborhood='$neighborhood', " .
"Business_Description='$businessdescription".
"Address_1='$address1', " .
"Address_2='$address2', " .
"City='$city', " .
"State='$state', " .
"Phone_Number='$phonenumber', " .
"E_Mail='email', " .
"Web_Site='$website', " .
"Contact_Name='$contactname', " .
"Date=CURDATE(),".
"Expiration_Date='$expirationdate'";
if (mysql_query($sql)) {
echo("<P>New Business Listing Added</P>");
} else {echo("<P>Error Adding New Business Listing: " .mysql_error() . "</P>");
}
?>

<P><A HREF="<?php echo($PHP_SELF); ?>">
Add Another Business Listing</A></P>
<P><A HREF="authors.php">Return to Authors list</A></P>
<?php else: // Allow The User To Enter A New Business Listing
?>
<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD=POST>
<P>Enter Business Information:<BR>
Business Name:
<INPUT TYPE=TEXT NAME="businessname" SIZE=50 MAXLENGTH=100><BR>
Sub Category:<select multiple name="subcategory[]">
<option value="Test">Test
<option value="Test2">Test 2
</select><br>