Posted by wombat on 02/09/07 00:56

I'm encountering the following problem:

I'm trying to create a new row by:

"INSERT INTO object_ix (name, address, phone, active) VALUES ('$a',
'$b', '$c', '$d')"

The "active" column is an ENUM to be set either YES or NO, however this
portion is failing to work. If I take out the "active" column, it works
just fine but I can't seem to be able to set an ENUM when creating the
row...

$d is set with a form using select with options YES and NO.

What am I doing wrong here?

Any help would be much appreciated. Thanks.

[Back to original message]