Mark Hensler — Fri, 27 Dec 2002 20:23:36 +0000

I translated the above PHP to ASP. I did this really fast.... hope it works.

<%

'assuming you already pulled these values from the database
Dim strNumberForDiscount = "5,10,15"
Dim strDiscountPercent = "10,15,20"
Dim fltProductCost = 3.99

'and this would be determined by what the customer is purchasing
Dim intPurchaseQuantity = 7

'make them arrays
Dim arrQuantities = Split(strNumberForDiscount, ",")
Dim arrPercentages = Split(strDiscountPercent, ",")

Dim fltThisDiscountPercent = 0
Dim i
For i=0 to UBound(arrQuantities)
    If intPurchaseQuantity >= intQuantities(i) Then
        fltThisDiscountPercent = arrPercentages(i)
    Else
        Break
    End If
Next

'determine the pre-discount total
fltThisPurchaseAmount = fltProductCost * intPurchaseQuantity

'determine the discount
fltThisDiscountAmount = fltThisPurchaseAmount * (ThisDiscountPercent / 100)

'subtract the discount
fltThisPurchaseAmount = fltThisPurchaseAmount - fltThisDiscountAmount

%>

ROB — Fri, 27 Dec 2002 17:39:45 +0000

yeah i realized that after i posted. im afraid i can be of little help there, but if ASP has a similar method to explode() to split a string into an array, converting the above to ASP should be fairly straight-forward.

cheers

mycoolross — Fri, 27 Dec 2002 17:29:22 +0000

Rob,

That is great! But I need ASP code. I appreciate your quick response.
Besides that any code that has an explode() function scares me.

- Mike

ROB — Fri, 27 Dec 2002 17:25:48 +0000

this will surely need some tweaking, but you should get the idea

<?php
//assuming you already pulled these values from the database
$NumberForDiscount = \"5,10,15\";
$DiscountPercent = \"10,15,20\";
$productcost = '3.99';

// and this would be determined by what the customer is purchasing
$purchasequantity = 7;

// make them arrays
$quantities = explode($NumberForDiscount, ',');
$percentages = explode($DiscountPercent, ',');

$thisdiscountpercent = 0;
for($i=0; $i<sizeof($quantities); ++$i) {
    if($purchasequantity >= $quantities[$i]) $thisdiscountpercent = $percentages[$i];
    else break;
}

// determine the pre-discount total
$thispurchaseamount = $productcost * $purchasequantity;

// determine the discount
$thisdiscountamount = $thispurchaseamount * ($thisdicountpercent / 100);

// subtract the discount
$thispurchaseamount -= $thisdiscountamount;
?>

[edit]DOH! NOT ASP!!!! Sorry i won't be of much help there[/edit]

mycoolross — Fri, 27 Dec 2002 17:20:15 +0000

By the way I forgot to mention this is ASP. I guess you can figure that out with the use of the dictionary object.

- Mike