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
>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?

By using a where clause to identify the postid in the table, something 
like this perhaps:

UPDATE header SET parent='$this->parent' where postid='$this->postid';

Greg Donald

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to