mysql_affected_rows problem

[Hodo]

Here is the code

$query = "INSERT INTO Ranscore SET pname = '$name', pscore = '$score', pdate = '$date' WHERE id = '$id' ";

$result = mysql_query($query)  or die ("Error in query: $query. ".mysql_error());

 

$rows = mysql_affected_rows($result);

 

and here is the response:

 

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

 

I just wanted to see if $rows was > 0

what am I doing wrong?

[AndyB]

Wrong argumentfor the function. Just use mysql_affected_rows()

 

http://www.php.net/mysql_affected_rows

[fenway]

Or the query failed....