Posted by fra on 10/06/06 10:49

hi everybody,
i got a strange problem with a simple mysql query in php.
simply, it doesn't work on my page (while it does through phpmyadmin):
there's the query:
$sql="
SELECT operatore, azione, COUNT( azione ), SUM ( numore )
FROM `utentiAzioni`
WHERE completata = '1'
GROUP BY operatore, azione ORDER BY operatore
"
the error message is:
"You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '( numore ) FROM `utentiAzioni` WHERE completata = '1' GROUP BY
a..."

any idea?
thanks in advance
francesco


--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

• Next in forum: Re: process a BIG string
• Prev in forum: Re: post of fetched value fails
• Thread view: mysql query in PHP

[Reply to this message]