List:MySQL and Perl« Previous MessageNext Message »
From:Jochen Wiedmann Date:June 8 2000 11:06am
Subject:Re: Nr of records
View as plain text  

Hans Scheffers wrote:
> 
> Hi,
> how can I get the number of records in a table.
> Also, How can I read teh result of an SQL staement, when for example I
> give
> $sth=$dbh->prepare("SELECT COUNT(*) FROM $table");
> $sth->execute;

	my($rows) = $sth->fetchrow_array();

(*Not*	my $rows =  $sth->fetchrow_array();	)
Thread
Nr of recordsHans Scheffers8 Jun
  • Re: Nr of recordsJochen Wiedmann8 Jun
    • Re: Nr of recordsHans Scheffers8 Jun
      • Re: Nr of recordsAdrian Phillips10 Jun