Quote:
Originally Posted by Phalynx
Your SQL Statement is wrong:
PHP Code:
SUM(counter) as sum_quotes
FROM " . TABLE_PREFIX . "quotes
WHERE userid=".$user['userid']);
counter seems not a column of the quotes table.
|
Many thanks! I changed it to the following and it seems to be working flawlessly:
PHP Code:
SUM(quotecount) as sum_quotes
FROM " . TABLE_PREFIX . "user
WHERE userid=".$user['userid']);
I also made some changes to the labeling where I had not changed the default expressions. I am attaching the final file in case anyone is interested.