invalid use of group function

[tom_b]

Hi,

I have some php scripts to use with a mysql database. I've tested them locally on my computer and they work fine, but when I put them on line I get the message "Invalid use of group function". Here are the group function statements:

$query = 'SELECT id, name, total FROM totals where id IN(select max(id) from totals group by name) ORDER BY total DESC ';
 
$query = 'SELECT name, SUM(total) AS numtotal FROM totals group by name order by sum(total) desc';
 

Any ideas why they won't work on line will be greatly appreciated!!

Thanks, Tom

[kovik]

"Invalid use of group function"

Wha...? You sure that's an SQL error? What does it say exactly?

[pbmods]

Heya, Tom.

Which query is generating that error?

[Atli]

Is it possible that the online server is running an ancient version of MySQL?

[tom_b]

Hi,

I'm not sure which of the statements is generating the error. When I get to that point the only thing on the page are the words "Invalid use of group function". The Mysql version is 4.1.14. Thanks for you time.

Tom

[pbmods]

Heya, Tom.

Ok. Try this:

$query = 'SELECT id, name, total FROM totals where id IN(select max(id) from totals group by name) ORDER BY total DESC ';
 
mysql_query($query);
echo $query, '<br />', mysql_error(), '<br /><br />';
 
$query = 'SELECT name, SUM(total) AS numtotal FROM totals group by name order by sum(total) desc';
 
mysql_query($query);
echo $query, '<br />', mysql_error(), '<br /><br />';
 

[tom_b]

Hi,

When I ran the queries through phpMyAdmin the first one worked fine, the second one generated this error;

#1111 - Invalid use of group function

Thanks, Tom

[pbmods]

This issue has been solved in the MySQL forum. The post is here:
http://www.thescripts.com/forum/thread691615.html

Further posts should be directed to that thread. This thread will now be closed.