"Srinivasan Ramakrishnan" <[EMAIL PROTECTED]> wrote in message
004701c206df$5a00f100$[EMAIL PROTECTED]">news:004701c206df$5a00f100$[EMAIL PROTECTED]...
> The slabs do not continue for an infinite number, hence I may only have
slab
> pricing for 1-10, 11-100, and 101-200 with the assumption that if there
are
> no higher slabs and I wanted say the rate for 500 licenses, I would use
the
> highest slab unit available, in this case the 101-200 slab.
... looking at this, the 'high-limit' value seems redundant
(it's always next_highest_minimum - 1); I would suggest
getting rid of it, ie
Table slabPricing:
slabID INT AUTO_INCREMENT
productID INT
slabStart INT
slabRate FLOAT(10,2)
> For example, what is the cost of 500 licenses of Product_ID 143 ?
SELECT slabRate FROM slabPricing
WHERE productID=143 AND slabStart<=500
ORDER BY slabStart DESC
LIMIT 1
... this will retrieve the per-piece rate for the
largest applicable slab.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
