fford; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] newbie: mysql statement
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
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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)"
--
PHP General Mailing List (h
;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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)"
If you could retrieve the max(posted) prior to doing the update you could;
SELECT max(posted) from header
WHERE parent = '$this->postid'
and substitute the value in the following query;
Update header SET parent='$this->parent'
WHERE parent = '$this->postid'
AND posted = $retrieved_posted
A sub
I would rewrite the query as:
"UPDATE header SET parent='$this->parent' WHERE max(posted) = max(posted)"
I would think this to work, though I don't have the facilities to test it, and have
never needed to do a query such as this. In theory, it should update ONLY the row
where the maximum valu
Oops, looks like I missed your Set after the ORDER BY. I've never seen it
there, usually I see it immediately after the update. Seem to me some
things in SQL are positional, but could be wrong here.
Warren Vail
Tools, Metrics & Quality Processes
(415) 667-7814
Pager (877) 774-9891
215 Fremont
On Mon, 15 Jul 2002, Alexander Ross wrote:
>I want to update the most recent record (based on the timestamp in field
>posted) where the parent field == a specified value (in a table called
>header).
>
>I tried the following mysql statement:
>
>"UPDATE header WHERE parent = '$this->postid' ORDER b
not only that, but you seem to be missing any SET field = value to cause
updates to occur. I suspect the reason that the ORDER BY is rejected is be
cause the database wants to use an index determined from your where clause
to optimize the update process. Keep in mind that no rows are returned to
8 matches
Mail list logo