[PHP3] $query question From: Margie Wiers (producti <email protected>)
Date: 04/30/00

Hello all--

Appreciate the help I've received in the past from this list.

Now I've run into something I can't figure out. I'm making an HTML form and
can't 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 don't show up in the table(maybe I'm
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,
Margie

PHP 3.0.14 / MySQL 3.23.12 / Apache 1.3.11 on Win95 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>