Posted by mick white on 02/09/07 16:07

wombat wrote:

> 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')"

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

I assume values are php variables.

Mick

>
> 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]