Sadly, I don't have any answers, only more questions.
First, how do you know your query is returning a FALSE result? What test are
you performing and what are the results of the test?
Second, what type of column is fee_recd?
I've been toying with the MAX() function on the command line with a
Usually you need to group on something for a max to work (at least in Oracle)
-Original Message-
From: Hutchins, Richard [EMAIL PROTECTED]
Sent: Jul 13, 2004 8:40 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Getting a result from MAX() query
Sadly, I don't have any answers, only more
[EMAIL PROTECTED] 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$latestbrError: . mysql_error());
but this one doesn't
$latest=mysql_query(SELECT fee_recd FROM members
[EMAIL PROTECTED] 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$latestbrError: . mysql_error());
Would you be kind enough to tell us what text mysql_error() shows?
You