Get actual rows affected after UPDATE

rupam_jaiswal

Hi,

mysql_query("UPDATE inventory SET username='$username' WHERE username='$target->username' ORDER BY RAND() LIMIT 15");

now I want to also display to the user which rows were affected by the above query and list all those rows in an echo or something.

I know i can use mysql_affected_rows() to find HOW MANY rows were affected but can you make a script that will list the rows that were affected? or is it not possible?

Regards

Pikachu2000

You would just need to run a SELECT query with the new values.

Pikachu2000

Wait a minute, is the username field a UNIQUE indexed field field or not?

rupam_jaiswal

Pikachu2000;10948385 wrote:
Wait a minute, is the username field a UNIQUE indexed field field or not?

No its not so.

rupam_jaiswal

Pikachu2000;10948384 wrote:
You would just need to run a SELECT query with the new values.

Hi,
There can be a records with username = '$username' even before running the UPDATE query, so If use SELECT * FROM inventory WHERE username = '$username' then it will fetch all the records which have not been modified by UPDATE command.
I want only the affected rows with the UPDATE command.
Regards

halojoy

As you have RAND() in your query to decide what rows to UPDATE
it will be impossible to get them after the update.
RAND() makes a random slection

But you can get a list of those updated
if you run one SELECT with RAND() first.

After this you can WHILE LOOP through the result
and do the UPDATE, row by row

The first select would probably be this query:

$result = mysql_query( "SELECT * FROM inventory 
    WHERE username='$target->username' ORDER BY RAND() LIMIT 15" );

$update_list = array();
while( $row = mysql_fetch_array($result) ){

// do the update for each $row 
// and put the username/id or whatever into $update_list
// UPDATE inventory SET ..... WHERE id=$row['id'];
$update_list[] = $row['username'];

}

echo '<pre>';
print_r( $update_list ); //TEST see those updated

?>