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
you from an update (which is where the ORDER BY is important).

Warren Vail
Tools, Metrics & Quality Processes
(415) 667-7814
Pager (877) 774-9891
215 Fremont 02-658

-----Original Message-----
From: Alexander Ross [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 11:56 AM
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

I tried the following mysql statement:

"UPDATE header WHERE parent = '$this->postid' ORDER by posted SET
parent='$this->parent' LIMIT1";

but apparently you can't use ORDER in an UPDATE statement.  If I take order
out, the statement works.  That being true (and please correct me if its
not) how can I ensure that the newest record is the one being acted upon?

PHP General Mailing List (
To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to