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)"
1:56 AM
To: [EMAIL PROTECTED]
Subject: [PHP] newbie: mysql statement
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 = &
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
5 Fremont 02-658
-Original Message-
From: Alexander Ross [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 11:56 AM
To: [EMAIL PROTECTED]
Subject: [PHP] newbie: mysql statement
I want to update the most recent record (based on the timestamp in field
posted) where the parent f
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
MAIL PROTECTED]
Subject: [PHP] newbie: mysql statement
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->
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 by posted SET
parent='$this->parent' LIMIT1";
but a
9 matches
Mail list logo