mysql_query(): how to check whether any rows are updated in case of UPDATE SQL

Question

I am using mysql_query() to execute UPDATE SQL on my table. I want to know whether the query has updated any row or not.

    // $query contains UPDATE SQL
$result = mysql_query($query, $connection);
if(!$result) {
    die("Database connection failed: " . mysql_error());
}

I tried to check value of $result, but it always comes out to be 1 for both cases(0 or more than 0 rows updated).

Can anyone please help.

Thanks.

jli · Accepted Answer · 2011-12-02 19:29:44Z

5

Use mysql_affected_rows(). It returns the number of modified rows in the last query run.

$numRows = mysql_affected_rows($connection).

answered Dec 2, 2011 at 19:29

jli

6,6432 gold badges31 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pilcrow · Accepted Answer · 2011-12-02 19:44:34Z

0

For completeness, you may also find this answer in SQL via the ROW_COUNT() function, although mysql_affected_rows is better for this task.

answered Dec 2, 2011 at 19:44

pilcrow

59.2k14 gold badges101 silver badges147 bronze badges

Comments

animuson · Accepted Answer · 2011-12-02 20:12:35Z

0

Try using mysql_affected_rows().

edited Dec 2, 2011 at 20:12

animuson♦

54.9k28 gold badges142 silver badges150 bronze badges

answered Dec 2, 2011 at 19:30

Jonathan Rich

1,73810 silver badges11 bronze badges

Collectives™ on Stack Overflow

mysql_query(): how to check whether any rows are updated in case of UPDATE SQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related