[Resolved] getting row count after doing an update on table

[Rulkster]

I have this piece of code:

$sql = "update products
set
weight =\"$newdata\"
where weight = \"$olddata\" ";
$result = @mysql_query($sql,$db)or die("$sql");
$total = mysql_num_rows($result);
echo "$total";

I am trying to get the number of rows that were affected with the update but i am getting this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ..........

What am i doing wrong here

Thanks for any help

[LordShryku]

[man]mysql_affected_rows[/man]

[Rulkster]

Okay, i changed it to:

$sql = "update mim_product_table
set
weight =\"$newdata\"
where weight = \"$olddata\" ";
$result = @mysql_query($sql,$db)or die("$sql");
$total = mysql_affected_rows($result); 
echo "$total";

and i get this error:

Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource

[LordShryku]

Is the data actually being updated?

[Rulkster]

yes it is, this seems to have solved it though:

$total = "Records updated: ". mysql_affected_rows();

Thanks for your help