MySQL/PHP error:Operand should contain 1 column(s)

Forum Moderators: open

Message Too Old, No Replies

MySQL/PHP error:Operand should contain 1 column(s)

krun

6:44 pm on Dec 9, 2006 (gmt 0)

I'v problem with my sql syntax:
SELECT (autor, autor_id, dodajacy, dodajacy_id, dataczas, nazwa, opis, id) FROM nuke_wBestiariusz_stwory ORDER BY nazwa

this syntax returned error:
Operand should contain 1 column(s)

Somone now what should I do?

justageek

6:52 pm on Dec 9, 2006 (gmt 0)

You should have a 'where' clause and remove the (). Something like:

SELECT autor, autor_id, dodajacy, dodajacy_id, dataczas, nazwa, opis, id FROM nuke_wBestiariusz_stwory where id=1 ORDER BY nazwa

JAG