On Sun, 14 Sep 2003, A.L.E.C wrote:

...

On Sun, 14 Sep 2003, A.L.E.C wrote:

oba zapytania koncza sie nastepujaco...

<HERE (cash.type = 3 OR cash.type = 4) GROUP BY users.id, status HAVING status = 3; ERROR 1054: Unknown column 'status' in 'having clause'

<d WHERE (cash.type = 3 OR cash.type = 4) GROUP BY users.id, name, lastname, status HAVING status = 3 ORDER BY balance; ERROR 1054: Unknown column 'status' in 'having clause'

co ten MySQL taki glupi, w GROUP BY mu nie przeszkadza, a w HAVING tak? Spróbuj status zamienic na users.status

i nic.... ani users.status HAVING status = 3 ani users.status HAVING users.status = 3 ani status HAVING users.status = 3

Pozdrawiam Pawel Bernadowski GG 3377, email kontakt@pbern.biz