How to know how many mysql lines updated

Question

I'm going to update a lot of database lines and i want to know how many lines i've updated.

Example : if i've database with the following 4 lines

INSERT INTO `drink` VALUES (1, 'Non-Alcoholic', 'tea');
INSERT INTO `drink` VALUES (2, 'Non-Alcoholic', 'tea');
INSERT INTO `drink` VALUES (3, 'Non-Alcoholic', 'coffee');
INSERT INTO `drink` VALUES (4, 'Non-Alcoholic', 'pepsi');

and i'm going to make updates using the following

$sql= "update drink set cat='tea' WHERE cat= 'Non-Alcoholic' AND subcat = 'tea'"; 

it would be clear that it would update only 2 lines

INSERT INTO `drink` VALUES (1, 'tea', 'tea'); 
INSERT INTO `drink` VALUES (2, 'tea', 'tea'); 
INSERT INTO `drink` VALUES (3,'Non-Alcoholic', 'coffee'); 
INSERT INTO `drink` VALUES (4,'Non-Alcoholic', 'pepsi');

Now my question how i know how many lines it have updated, i want it to be shown as message or whatever but i must know it.

so any idea or how to do it thank you for help

Answer 1

You need mysqli::affected_rows();

Answer 2

Use mysql_affected_rows http://php.net/manual/ro/function.mysql-affected-rows.php

Answer 3

You can do it with PHP : mysql_affected_rows() or in C : mysql_info()

Answer 4

This code will count the number of rows (entries / records) in a MySQL database table and then display it using echo on the screen

<?php 



// Connect to the database 
db_connect(); 

// Query the database and get the count 
$result = mysql_query("SELECT * FROM drink"); 
$num_rows = mysql_affected_rows($result); 

// Display the results 
echo $num_rows; 

?>

Answer 5

mysql_affected_rows : Get number of affected rows in previous MySQL operation :

...
$updated_count = mysql_affected_rows();
...

Put above statement after your queries to count the affected rows.

Answer 6

You can either use the php function mysql_affected_rows() or mysqli_affected_rows()

Or follow up the update statement with a sql statement.

SELECT row_count() as affected_rows 

Mysql: http://www.php.net/manual/en/function.mysql-affected-rows.php
Mysqli: http://php.net/manual/en/mysqli.affected-rows.php http://dev.mysql.com/doc/refman/5.0/en/information-functions.html