PHP Help - It's Driving me nuts

[Northern Monkey]

Tweet

Have got the following code in my script:

$query = "UPDATE Petitions SET signatures='$sigs', lastupdate='NOW()' WHERE pet_id='$pid'";

$result = @mysql_query ($query);
echo "Num $num <br>";
$num = @mysql_num_rows ($result);
echo "Num $num <br>";

Problems is that even though the tables are updated with the correct values, the value of $num remains undefined. Anyone got any ideas?

[Rich]

See this: - http://uk2.php.net/mysql_num_rows

To retrieve the number of rows affected by a INSERT, UPDATE or DELETE query, use mysql_affected_rows().

... instead of mysql_num_rows()

[Northern Monkey]

Damn, school boy error, cheers!