Greetings - I have a simple CGI script written in Perl (using v5.8) that seemed to work well under MySQL 3.23.49. However, after recently upgrading to version 3.23.55 I am running into the following problem. Previously, I used the rows() function to return the number of rows returned from a SELECT query as in the example below. However, this has now ceased to function as before, and returns zero (0) in the $count variable no matter what is returned from the database. Can anyone tell what might have changed, or what I might do to get around this problem?
#Set the database query my $query = "SELECT * FROM table_name"; #Run a query to return all records my $sth = $dbh->prepare($query); $sth->execute; #Count the number of records returned my $count=$sth->rows(); Many thanks for any help you can provide... Colin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php