From your suggestion, this is what i printed:

$Sql="SELECT * FROM Cust_act_da WHERE CustomerNumber = $CustomerNumber
+ AND TransType = 'P'";
    print $Sql;
    $db->SQL( $sql );
[download]

and I get this when SQL is printed: "SELECT * FROM Cust_act_da WHERE CustomerNumber = 13 AND TransType = 'P' " This is what I have in my code:

    while ($CustomerNumber = $Data{"CustomerNumber"}) {
         $db->Sql("SELECT * FROM Cust_act_da WHERE CustomerNumber = $C
+ustomerNumber AND TransType = 'P'");
[download]