If result is true, I take this to mean that the query could be executed.
And I take MySQL affected rows to mean that N rows were affected AND the
result was true:

$sql = "SELECT * FROM ...";
$result = mysql_query($sql);
    // it did work
    echo mysql_affected_rows();
    // it didn't work
    echo mysql_error();

I haven't dug right down to make sure this method works for every problem,
but so far, no problems found.

Justin French

on 01/10/02 2:23 AM, Henry ([EMAIL PROTECTED]) wrote:

> Hi All,
> mysql_affected_rows() returns zero if you update without changing the data
> in a database record. How do you tell the difference betwix "it worked but
> nothing changed" as opposed to "it didn't work"?
> Henry

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to