get row id after an update?

cretaceous

is there a way to get an id after an update, kind of like
mysql_insert_id();

my 'sql' is this:

$sql = "UPDATE rvus SET tied_id='', ties=('$ties'-1) WHERE tied_id='$revu_id' LIMIT 1 ";

I want the id of the row affected or do I just have to do a new SELECT?

devinemke

which field do you want? you already have the tied_id.

cretaceous

no, its the revu_id I need - its a recursive system and I'm basically doing a blind update to move an entry up a recursion level ... and then reset any child rows with the new id

cretaceous

I have it working but I have to do four queries..

all the rows I want to change (apart from the parent) have the same tied_id - (that's the parent's row id):

1) $sql="SELECT revu_id FROM rvus WHERE tied_id='$revu_id' ORDER BY dat LIMIT 1";
$temprevid = $row["revu_id"];
gets the relevant id of the item that will be new parent

2) $sql = "UPDATE rvus SET tied_id='0', ties=('$ties'-1) WHERE revu_id='$temprevid' ";
changes that row to how I want it

3) $sql = "UPDATE rvus SET tied_id='$temprevid' WHERE tied_id='$revu_id' ";
changes all other rows with the same reference (tied_id) to have the new parent id

4) $sql = "DELETE FROM rvus WHERE revu_id=$revu_id";
deletes the original parent row

is there a more elegant way ? !

cretaceous

sorry - I posted this query last week so some of you may have read it before but I'm sure there must be a cleaner solution

slightly rephrased:

I have a recursive entry system and I need to be able to delete a parent entry and make the first child the new parent to the other siblings

right now it works but I have to do four queries..
("$revu_id" is the old parent id )

$sql="SELECT revu_id FROM rvus WHERE tied_id='$revu_id' ORDER BY dat LIMIT 1";
    while etc {   $temprevid = $row["revu_id"]; }

//finds the relevant id of the item that will be new parent (I have no way of knowing what the first child is offhand)


$sql = "UPDATE rvus SET tied_id='0', ties=('$ties'-1) WHERE revu_id='$temprevid' ";
//changes that row to be parent

$sql = "UPDATE rvus SET tied_id='$temprevid' WHERE tied_id='$revu_id' ";
//changes siblings to have the new parent id

$sql = "DELETE FROM rvus WHERE revu_id=$revu_id";
//deletes the original parent row

please let me know if I should just stop worrying that it's messy !