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
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-postid' ORDER by posted
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 by posted
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 field
] 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-postid' ORDER by posted SET
parent
= max(posted)
Otherwise the max(posted) = max(posted) is true for all records (therefore
all records get updated)
Andrew
- Original Message -
From: Martin Clifford [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 8:11 PM
Subject: Re: [PHP] newbie
]
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 updated)
Andrew
- Original Message -
From: Martin Clifford [EMAIL
7 matches
Mail list logo