- 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";
- or download this
$SqlStatement->execute($CustomerNumber);
- or download this
while ( @stuff = $SqlStatement->fetchrow() ) {
- or download this
# do things with @stuff
$FormatTransDate = substr($TransDate, 0, 10);
...
print " ";
print $FormatTransPmtAmt;
}