2 replies to this topic

[andrew.craig]

Hi, can anyone help me with the following:
I am trying to get the MAX or MIN value from a table together with it's associated 'id'.
My SQL statement looks like:

$sql = "SELECT MAX(weight) as maxWeight, id FROM $Log where uid = '$id' GROUP BY id";
$result = mysql_query($sql);

I then do the following:
while (($row = mysql_fetch_row($result)))
{
echo $row[0] . "<BR>";
echo $row[1] . "<BR>";
}

hoping that I would get the maximum value coming out of $row[0] and the id of the row that contains that maximum value out of $row[1]

This doesn't appear to work for me.

What I have done is just a straight forward:
SELECT id, weight FROM $Log where uid = '$id' order by weight DESC LIMIT 0,1
to get the maximum value - is this a stupid way of getting the maximum value ie is there any speed difference in using the MAX() function?

Any help would be appreciated.
Thanks for your time.
Cheers
Andrew

[adam123]

Moved to correct forum.

[fiv3isaliv3]

your query is wrong it appears. here is a page from the MySQL manual http://dev.mysql.com/doc/mysql/en/example-...lumn-group.html ... i looked for a page about MIN but i couldn't find it. i'll leave that one to you.