db_affected_rows

[bjblackmore]

Hi,
I'm trying to check 5 queries, which are update statements. I have $result1, $result2.....$result5. So I have done
if (db_affected_rows($result1) < 1 || db_affected_rows($result2) < 1 || db_affected_rows($result3) < 1 || db_affected_rows($result4) < 1 || db_affected_rows($result5) < 1){
$feedback .= ' NOTHING Changed ';
} else {
$feedback .= ' Info Changed ';
}
However even if I update the query that is $result1 it still says 'NOTHING Changed'. The only time it says 'Info Changed' is if $result5 is updated.
What am I doing wrong?
Regards
Ben

[herve]

parenthetis , ie :

if ( (condition1) || (condition2) )
{
}

will do what you have in mind (test one
condition then/or an other)

if ( condition1 || condition2 )
{
}

will do a "logical or" between the two parts
and the if() will be true only when the
"logical or" will return 1

[bjblackmore]

Hi,
Thanks for replying.
I just did..
if ((db_affected_rows($result1) < 1) && (db_affected_rows($result2) < 1) && (db_affected_rows($result3) < 1) && (db_affected_rows($result4) < 1) && (db_affected_rows($result5) < 1))
That way only if they all = <1 will it return 'NOTHING Changed' however it still says that even if $result1 is changed. The only time it says 'Info Changed' is when $result5 is updated.
Can you see whats wrong with my code?
Many Thanks
Ben

[herve]

Verify (by printing them) the value of each of your db_affected_rows()

(BTW is it mysql_affected_rows() function
you're refering to or a special function
of your own ?)

if dealing with mysql_affected_rows(), take
care :

mysql_affected_rows() works with connection handles returned by mysql_connect() or
mysql_pconnect(), not with result handles
returned by mysql_query() or
mysql_db_query() ]

[bjblackmore]

db_affected_rows is basically mysql_affected_rows, but it connects 1st. Just a function so I don't have to keep connection and specifying the database.
In my script the table content is printed out at the start, then you can choose to update the table. If its updated you can see the changes. Which I can, when i change row 1 - 5. However it only gives feedback saying info changed on row 5.

[herve]

A small digest of how it should be :

--- 8< ---
$db=mysql_connect ("localhost","login",pwd");

$cmd="UPDATE mytable SET name='$name'";
$result=mysql_query($cmd,$db);
if (!$result)
{ ErrorMsg();
}
$nb_rows1 = mysql_affected_rows($db);

$cmd="UPDATE mytable SET name='$name'";
$result=mysql_query($cmd,$db);
if (!$result)
{ ErrorMsg();
}
$nb_rows2 = mysql_affected_rows($db);

...

if ( ($nb_rows1 < 1) && ($nb_rows2 < 1) )
{

}

--- 8< ---

why would you replace mysql_affected_rows ?

(if $db is a global variable, you can
do the mysql_connect at the beginning of
your program and use it by saying
"global $db;" at the beginning of the function calling mysql_affected_rows() for
instance)