Gossamer Forum: General: Databases and SQL: print out group by result

May 4, 2002, 6:45 PM

courierb

User (344 posts)

May 4, 2002, 6:45 PM

Post #1 of 3

Shortcut

print out group by result

In command line below code works ok.

mysql> SELECT studentstatus, COUNT(*)FROM studentdb GROUP BY studentstatus;

the result wil be :

status1 20

status2 40

status3 18

My question is how to make these value print out in webpage. any code could be used?

I could not know how to handle COUNT(*) value.

Thanks

May 4, 2002, 9:43 PM

sponge

Veteran (1936 posts)

May 4, 2002, 9:43 PM

Post #2 of 3

Shortcut

Re: [courierb] print out group by result In reply to

If you have Perl, then you need to install DBI and DBD::mysql. Once you do that, you need to write a Perl program, which does something like:

Code:
#!/usr/local/bin/perl 
use DBI; 
use CGI::Carp qw(fatalsToBrowser); 

my $dbh = DBI->connect("DBI:mysql", "username", "password") or die DBI->errstr; 
my $sth = $dbh->prepare("select studentstatus, count(*) from studentdb group by studentstatus") or die DBI->errstr; 
$sth->execute() or die DBI->errstr; 
print "Content-type: text/plain\n\n"; 
while (my $rec = $sth->fetchrow_arrayref()) { 
  print "$rec->[0] : $rec->[1]\n"; 
} 
$dbh->disconnect();

--Philip
Links 2.0 moderator

May 5, 2002, 3:56 AM

courierb

User (344 posts)

May 5, 2002, 3:56 AM

Post #3 of 3

Shortcut

Re: [sponge] print out group by result In reply to

Thanks very much sponge . it works nicely now.