CF not retrieving all records in a query

Question

Hi all,We have an intertesting problem here, where the submit from the previous form works and the d/base write is committed successfuly, however the next form which should retrive the previous information returns n-1 number of records (1 less than are in the d/base). It almost as if the form looking up the information after submission has started its processing before the final write commit has been completed in the d/base (mySQL)Details:This problem here is that not all the records are being retrieved by the query when the variable value ($regoNum), which is retrived from the $_POST array is used in the query. It works fine (i.e correct number of records are retrieved) if the variable $regoNum is hardcode to a value. (see screen shot attached. there were 2 records in the d/base and 2 are shown and yes there is a prob with the calculation logic but I'll fix that later  :? ) [attachment=0]paypalpreconf.jpg[/attachment] As you can see from the code in Exibit#2 , $reogNum is also printed out to ensure I could retrieve it, and this works OK.The sympotoms are as follows:previous form (regoform4) submits and writes successfuly to the d/base. This form has the code in exibit #1 in the "On Submit code - after sending email:" section. The action is successful and the paypal preconfirmation form is shownthe issue is that the paypal preconfirmation form- in Exibit #2 - uses the variable $regoNum as the selector for which records to return.If there is only one record that macthes the variable, no records are returned. If there are multiple records that match the variable value, then n-1 records are returned. (i.e 1 less than the record count in the d/base).Can offer any advice here? If you need to, you can test the process by going to http://test.wphcfc.net.au and clicking on online-registration. By clicking on the all Reports menu item (uses CC), you can see the registrations that are in the d/base.ThanksajExibit #1showForm('regoform1', $posted);
}
else {
    $MyForm->showForm('paypal', $posted); 
}
?>Exibit #2 - paypal preconfirmation form.PayPal Pre-confirmation Information

#
  Registration ID
  Name
  Age Group
  Student Discount Requested
  Registration Charge $

setQuery($query);
$t_rows = $db->loadRowList();
foreach ( $t_rows as $t_row ) {
$i++;
switch ($t_row[4]) {
    case "U6":
        $amt=6;
        break;
    case "U7":
        $amt=7;
        break;
    case "U8":
        $amt=8;
        break;
    case "U9":
        $amt=9;
        break;
    case "U10":
        $amt=10;
        break;
    case "U11":
        $amt=11;
        break;
    case "U12":
        $amt=12;
        break;
    case "U13":
        $amt=13;
        break;
    case "U14":
        $amt=14;
        break;
    case "U15":
        $amt=15;
        break;
    case "U16":
        $amt=16;
        break;
    case "U17":
        $amt=17;
        break;
    case "U18":
        $amt=18;
        break;
    case "U19/21":
        $amt=21;
    case "All Age":
        $amt=25;
        break;
    case "Prem-League":
        $amt=30;
        break;
    case "Over35":
        $amt=35;
        break;      
}
$amtFmtd = number_format($amt,2);
$sTotCalc = $sTotal + $amt;
$sTotal = number_format($sTotCalc,2);
?>

-

';
print '';
       }
//penalties/discounts & total variables here
$earlyLate='early';
$early=-0.10;
$late10=0.10;
$late20=0.20;
$gTotal=0.00;

//penalty-discount calcs here
if ($earlyLate=='late10')
{
$pdDesc='10% Late Fee';
$gTotCalc = $sTotal*(1+$late10);
$gTotal = number_format($gTotCalc,2);
$pdFeeCalc = $sTotal*$late10;
$pdFee= number_format($pdFeeCalc,2);
}
elseif($earlyLate=='late20')
{
$gTotCalc = $sTotal*(1+$late20);
$gTotal = number_format($gTotCalc,2);
$pdDesc='20% Late Registration Fee';
$pdFeeCalc = $sTotal*$late20;
$pdFee= number_format($pdFeeCalc,2);
}
elseif($earlyLate=='early')
{
$gTotCalc = $sTotal*(1+$early);
$gTotal = number_format($gTotCalc,2);
//$gTotal = $sTotal*(1-$early);
$pdDesc='10% Early Registration Discount';
$pdFeeCalc = $sTotal*$early;
$pdFee= number_format($pdFeeCalc,2);
}
else
$gTotal = number_format($sTotal,2);
//p-d item creation for paypal
$itemPD = 'item_'.($i+1);
$feeAmt = "amount_".($i+1);
print '';
print ''.$itemPD.$pdDesc.''; 
print ''.$feeAmt.$pdFee.'';
print '';
print '';
print '';   
?>

Subtotal

Extra Charges

Total

//other variable for paypal submission
" />

Forums

CF not retrieving all records in a query