Help for this page

Select Code to Download


  1. or download this
    $SqlStatement=$db->prepare("SELECT TransDate, TransPmtAmt FROM Cust_ac
    +t_da WHERE CustomerNumber = ? AND TransType = 'P'") or die "prepare f
    +a
    +iled: " . $db->errstr()."\n";
    
  2. or download this
        $SqlStatement->execute($CustomerNumber);
    
  3. or download this
        while ( @stuff = $SqlStatement->fetchrow() ) {
    
  4. or download this
         # do things with @stuff
            $FormatTransDate = substr($TransDate, 0, 10);
    ...
                 print "    ";
                 print $FormatTransPmtAmt;
        }