I've built a PHP page that makes a dropdown list based on an enum field in a mySQL database.
The creation and population of the list box works just fine. After selecting a value from the box and submitting the form, the value is transmitted to the new page without a problem.
However, the following query, while it works for every other field, does not populate the field that is the enum type:
PHP:
$query = "INSERT INTO advertisement VALUES(NULL, '$SES_member_ID', '$adSection', '$adDescription',
'$adPrice', '$adPriceComment', '$adContact', '$adContactEmail', '$adThumbimg', '$adFullimg',
'N', curdate())";
The offending variable is $adSection. I've echoed it out on the very line just before $query, and it holds the proper value. Yet, the database field is always empty. Below is the description of the field in question:
| Field | Type | Null | Key | Default | Extra |
| adSection |
enum('1961 Tempest Parts List','1962 Tempest/Lemans Parts List','1963 Tempest/Lemans Parts List','Pontiac (Non 61-63 Tempest/Lemans) Parts List','Non-Pontiace Car-Related Parts List','Manuals and Literature List','Memorabilia and Collectibles List','Tools, Equipment and Shop Items List','Members "Stuff for Sale" List') | | | Members "Stuff for Sale" List | |
I'm lost. Any help would be appreciated.
xhat
