"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