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
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