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
Joao Prado Maia wrote:
>
> On Wed, 21 Nov 2001, Martin Jansen wrote:
>
> > On Wed, 21 Nov 2001 09:19:44 -0500 (EST), Joao Prado Maia wrote:
> >
> > >If PEAR::DB is not abstracting the database what is the purpose of such a
> > >library ?
> >
> > To ease the life of lot's of programmers.
> >
>
>
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
Jonathan,
What happens if you take out the comma before the WHERE (as well)?
=dn
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Jonathan Underfoot" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: 23 November 2001 17:41
Subject: Re: [PHP-DB] PHP & MySql
> At 4:16 PM
On Fri, 23 Nov 2001 14:04:00 -0600
Terry Romine Terry Romine <[EMAIL PROTECTED]> wrote:
> I seem to have run into a strange bug where when I enter text
> through a
> form, and use the nl2br call in PHP, instead of getting "" I
> get
> "" and then my parsing fails on the display side (where I
>