Re: [PHP-DB] Retrieving rows matched when using UPDATE in PHP/MySQL

2001-11-24 Thread DL Neil
John, > > > How do I retrieve these values using PHP and the MySQL lib? (I'm > > >especially interested in the "Rows matched" value since the Rows > affected > >function isn't enough to determine why an update resulted > in 0 rows > >changed). > > > >It is common practice to check the db BEFORE p

[PHP-DB] Retrieving rows matched when using UPDATE in PHP/MySQL

2001-11-24 Thread John Paulsson
When I manually do an update using MySQL I get extended query result like "Rows matched", "ChangeD" and "Warnings". See example below: " UPDATE Foo SET bar = 'value' WHERE ID = 666; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 " How do I retrieve these values u