Help for this page

Select Code to Download


  1. or download this
    $dbh = DBI->connect("DBI:mysql:database=$serverDb;host=$serverName;por
    +t=$serverPort",$serverUser,$serverPass);
    $sth = $dbh->prepare("SELECT code,number FROM $serverTabl_4 WHERE name
    + = ? ORDER BY number DESC");
    ...
      $codes{$ref->{code}} = $ref->{number};
      print $ref->{number},"\n"; 
    }
    
  2. or download this
    $dbh = DBI->connect("DBI:mysql:database=$serverDb;host=$serverName;por
    +t=$serverPort",$serverUser,$serverPass);
    $sth = $dbh->prepare("SELECT code,sum(number) FROM $serverTabl_4 group
    + by code");
    ...
     # $sum{$ref->{code}} = $ref->{number};
     print $ref->{number},"\n"; 
    }
    
  3. or download this
    +------+-------------+
    | code | sum(number) |
    +------+-------------+
    ...
    |   24 |          84 |
    |   25 |          43 |
    |   26 |          14 |