update query & mysql_affected_rows()

[aniesh82]

Hi,

 

I have an UPDATE query and after executes it, I need to find out the ids of the records where the actual updation occurs.. I can find out the 'total updation' using the mysql_affected_rows() function.. But is there any php function or class available for this specific purpose?

 

thank you,

php developer,

Cochin-India.

[pocobueno1388]

Before you do the update, just do a select query that has the same WHERE clause as the update query.

[MatthewJ]

Just a thought as I am sure there is a better way, but when you're doing the update I would assume the update SQL specifies which row to update or it would not update the proper item... If so, you must b e passwing the id as part of the WHERE clause.

 

Could you loop through the items you are updating and add that id to an array after each query is executed?

 

For instance:

 

$ids = array(1, 3, 5, 7, 9);

foreach($ids as $v) {
    $SQL = "UPDATE table SET field = 'value' WHERE recordid = $v";
    $res = mysql_query($SQL, $conn);
    if($res) {
           $updated[] = $v
    }
}

 

Obviously the first array is just for examples sake

 

Just a thought