re Hello all --
Appreciate the help I`ve received in the past from this list.
Now Ive run into something I cant figure out. Im making an HTML form and
cant get the values of the single select menu (created in the TABLE with
ENUM() )and the multiple select menu (SET() ) to go into the table. (The
textboxes and textareas from the form pose no problem.) The problem is
selections from ENUM() and SET() just dont show up in the table(maybe Im
leaving something out of my query?).
/ / $industries is the multiple select
/ / $industry is the single select
$industries = addslashes(implode(", ", $industries));
$query="INSERT INTO member(lastname,firstname,username,email,
industry,worktelephone,expertise,industries)
VALUES($lastname,$firstname,$username,$email,
$industry,$worktelephone,$expertise,$industries )";
/ / the HTML from the previous page is what you`d expect
/ / industries:
<SELECT NAME="industries[]" MULTIPLE SIZE="4">
<option>Accommodation and Food Services</option>
<option>Admin., Support, Waste Mgmt., Remediation</option>
<option>Agriculture, Forestry, Fishing, Hunting</option>
<option>Arts, Entertainment, Recreation</option>
. . .
</SELECT>
/ / industry:
<SELECT name="industry">
<option value="AC">Accommodation and Food Services</option>
<option value="AD">Admin., Support, Waste Mgmt., Remediation</option>
<option value="AG">Agriculture, Forestry, Fishing, Hunting</option>
<option value="AR">Arts, Entertainment, Recreation</option>
. . .
</SELECT>
Can anyone see what I`m doing wrong? Or leaving out?
Thanks,
