Hello Dave,
Tuesday, January 13, 2004, 12:57:35 PM, you wrote:
DC> If I use this sql in my func:
DC> $sql = mysql_query("select count(fieldtocount) as cnt, sum(fieldforsum) as
DC> total from $tab3 where fieldtocompare =\"$varcomparedwith\"");
DC> Then all is fine and works as expected.
Is this MySQL? If so you can't have a COUNT + SUM without a GROUP BY.
--
Best regards,
Richard mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
