[PHP] newbie: mysql statement

2002-07-15 Thread Alexander Ross
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

RE: [PHP] newbie: mysql statement

2002-07-15 Thread Vail, Warren
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

Re: [PHP] newbie: mysql statement

2002-07-15 Thread Greg Donald
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

RE: [PHP] newbie: mysql statement

2002-07-15 Thread Vail, Warren
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

RE: [PHP] newbie: mysql statement

2002-07-15 Thread Vail, Warren
] 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

Re: [PHP] newbie: mysql statement

2002-07-15 Thread Martin Clifford
= 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

RE: [PHP] newbie: mysql statement

2002-07-15 Thread Vail, Warren
] 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