Posted by Captain Paralytic on 02/09/07 10:07

On 9 Feb, 00:56, wombat <6...@k.com> 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')"
>
> 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.

"however this portion is failing to work"
How is it failing to work? Are you getting an error message? Are all
the fields apart from that one getting inserted? Is no row getting
inserted?
We need a bit more info here than "it doesn't work".

Try echoing the string so that you can see what the final query looks
like then paste it into phpmyadmin and see what that says about it.

[Back to original message]