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

Re: [PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV]Adoption of Metabase

2001-11-24 Thread Stig S. Bakken
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. I probably used a

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

Re: [PHP-DB] PHP MySql

2001-11-24 Thread DL Neil
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 -0700

Re: [PHP-DB] php3-php4 mysql problem with nl2br coding

2001-11-24 Thread Raquel Rice
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 BR I get BR / and then my parsing fails on the display side (where I use