Re: Getting a result from MAX() query

From:	Doug Thompson	Date:	Tue, 13 Jul 2004 13:48:28 +0000
Subject:	Re: Getting a result from MAX() query
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-35214@lists.php.net to get a copy of this message

boclair@boclair.com wrote:

Would somebody be kind enough to explain why this query produces a false result $latest=mysql_query("SELECT MAX(fee_recd) FROM members",$connectup)or die ("Query failed:<br>$latest<br>Error: " . mysql_error()); but this one doesn't $latest=mysql_query("SELECT fee_recd FROM members ORDER BY fee_recd DESC LIMIT 1",$connectup)or die ("Query failed:<br>$latest<br>Error: " . mysql_error()); Louise

Here's a concept: RTM "In MySQL versions prior to Version 3.22.5, you can use MAX() instead of GREATEST. " What does your inquiry have to do with PHP? Doug