Re: newbie: mysql statement
| From: | Andrew Brampton | Date: | Mon, 15 Jul 2002 19:23:15 +0000 |
| Subject: | Re: newbie: mysql statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-107745@lists.php.net to get a copy of this message | ||
Shouldn't this be
"UPDATE header SET parent='$this->parent' WHERE posted = max(posted)"
Otherwise the max(posted) = max(posted) is true for all records (therefore
all records get updated)
Andrew
----- Original Message -----
From: "Martin Clifford" <MLC1@nrc.gov>
To: <alexross@bleen.net>; <php-general@lists.php.net>
Sent: Monday, July 15, 2002 8:11 PM
Subject: Re: [PHP] newbie: mysql statement
I would rewrite the query as:
"UPDATE header SET parent='$this->parent' WHERE max(posted) = max(posted)"