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

Reply via email to