azadi (thanks for everyones help by the way)... SELECT pricing.* FROM pricing PCP WHERE product_min >= 6 ORDER BY product_min, (product_min/6) LIMIT 1;
does not work as it outputs the price for where a min qty of 10 applies. it should output the price where the min is 5. i am thinking of going williams way where i put in an initial row with a min qty of 1 so i can capture 1-5, 6-10, 10+ etc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333384 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm