affected_rows puzzle

[audiopro]

Not sure whether this should be posted here or in MySQL as it is a MySQL query via DBI from a perl script.
I need to get the number of rows affected during a query.
I have been searching round for the syntax and the different versions are confusing.

my $rows = $sth->affectedrows;
my $rows = $sth->affected_rows;
my $rows = $sth->affected_rows();
my $rows = $sth->mysql_affected_rows();

None of these appear to work, have I got the right syntax or am I doing the call all wrong?


Keith

 

[audiopro]

Sorry.
The standard

my $ra = $sth->rows;

does the job

Keith