Hi.
This is the documented behaviour. For details, see
http://www.mysql.com/doc/G/r/Group_by_functions.html
How to deal with this is discussed in the tutorial section:
http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html
Bye,
Benjamin.
On Sat, Mar 30, 2002 at 09:24:26PM
From: Mike Yuen <[EMAIL PROTECTED]>
> The query I have is: select max(mid) from mboard;
> BUT I tried the following in PHP and it doesn't work:
>
> $myquery = "SELECT max(mid) FROM mboard";
> $myresult = mysql_query($myquery);
> $row = mysql_fetch_object($myresult);
> print "$row->mid is result
It works without the group by clause also.
As in:
select max(debt) from users;
Roger Ramirez wrote:
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Gro
> up_by_functions
>
> max(x) works with the group by clause.
>
> > -Original Message-
> > From: Roman Are
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Gro
up_by_functions
max(x) works with the group by clause.
> -Original Message-
> From: Roman Arefiev [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 10:25 AM
> To: [EMAIL PROTECTED]
> Subject: Max valu
