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());
Would you be kind enough to tell us what text mysql_error() shows?
You probably just need to use an alias in your query:
SELECT MAX(fee_recd) AS max_fee_recd FROM members
and then you'll have $row['max_fee_recd'] when you fetch the value from your result set. Other wise you need to use $row['MAX(fee_recd)']...
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
