[PHP-DB] Re : [PHP-DB] MySQL Update Quandry

2005-11-28 Thread Neil Smith [MVP, Digital media]
Message-ID: <[EMAIL PROTECTED]> Date: Sun, 27 Nov 2005 12:49:17 -0500 From: Glenn DeschĂȘnes <[EMAIL PROTECTED]> To: php-db@lists.php.net MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_Part_11492_6161784.1133113757293" Subject: Re: [PHP-DB

Re: [PHP-DB] MySQL Update Quandry

2005-11-27 Thread Glenn DeschĂȘnes
This is not the problem. The query fails when there is, as examples, an invalid syntax in the query or the table is not found. However, if the query executes but updates nothing. How can I know when the update has changed a row or not? Not changing a row does not return a failure. Matt's solution

RE: [PHP-DB] MySQL Update Quandry

2005-11-26 Thread Rich Hutchins
Please forgive me as I've been working with C# recently so my PHP is a little rusty. But if I'm reading this correctly... If your query fails outright, your function is going to return false: "if (!(@ mysql_query($query, $connection))) { $this->errors = array(mysql_errno(), mysql_error());