RE: help with count query in mysql

[Bob Showalter]

> -Original Message-
> From: FLAHERTY, JIM-CONT [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 3:06 PM
> To: Beginners (E-mail)
> Subject: help with count query in mysql 
> 
> 
> How do you  do a count query in mysql ?  I have redhat 7.1 
> mysql 3.23   
>  
> code  
>  
>  
> ##
> # get stats
> ##
>  
> use DBI;
> my $database = "VHD";
> my $data_source = "DBI:mysql:$database";
> my $username = "name";
> my $password = "password";
>  
> $dbh =DBI ->connect($data_source, $username, $password);
> my $sth1 = $dbh -> prepare("select count(*) from jobs where status =
> 'closed'");
> $sth1 -> execute or die " unable to execute query ";
>  
> 
> my $array_ref = $sth1 -> fetchall_arrayref();
>   foreach $row(@$array_ref){
> my($closedJ) = @$row;
 
 This should be your count here.

> # print LOG "$row";
> print LOG "$closedj[0]";

$closedJ (not closedj) is the count, not an array.

>  
> }
> $dbh -> disconnect;

You can wrap up the prepare/execute/fetch all in one statement
by doing something like this:

   my ($n) = $dbh->selectall_array(
   "select count(*) from jobs where status = 'closed'"
   );
   die $DBI::errstr if $DBI::err;

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

help with count query in mysql

[FLAHERTY, JIM-CONT]

How do you  do a count query in mysql ?  I have redhat 7.1 mysql 3.23   
 
code  
 
 
##
# get stats
##
 
use DBI;
my $database = "VHD";
my $data_source = "DBI:mysql:$database";
my $username = "name";
my $password = "password";
 
$dbh =DBI ->connect($data_source, $username, $password);
my $sth1 = $dbh -> prepare("select count(*) from jobs where status =
'closed'");
$sth1 -> execute or die " unable to execute query ";
 

my $array_ref = $sth1 -> fetchall_arrayref();
  foreach $row(@$array_ref){
my($closedJ) = @$row;
# print LOG "$row";
print LOG "$closedj[0]";
 
}
$dbh -> disconnect;
 
 
 
thank you in advance
 
Jim F