"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> [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:$latestEr
[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:$latestError: " . mysql_error());
Would you be kind enough to tell us what text mysql_error() shows?
You
[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:$latestError: " . mysql_error());
but this one doesn't
$latest=mysql_query("SELECT fee_recd FROM members
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 h
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 num
