newbie: mysql statement

From: Date: Mon, 15 Jul 2002 18:56:17 +0000
Subject: newbie: mysql statement
Groups: php.general 
Request: Send a blank email to php-general+get-107737@lists.php.net to get a copy of this message
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 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? Thanks.

« previous php.general (#107737) next »