i have to admit, i didnt read your whole thing, but maybe this will work. take the max, MOD 25000 to get the remainder, and then subtract that from the max...
On 4/5/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > I'm working on a site for a realtor. It has a "search by price" feature with > a low and a high end. The realtor would like both dropdowns to start at the > closest increment of $25,000 in the database so that the user could > conceivably just hit the submit button and get results. Right now I'm > prepoulating them both at $25k, the minimum. > > Anyway, assuming the max price in the db was $269,000, I need the high > dropdown to max out at $275,000. If the minimum price was $111,000, the low > dropdown needs to min out at $100,000. > > Does anyone have suggestions on the best way to accomplish this? I know how > to get the min and max values from the db, just not sure how to "round" to > the nearest $25,000 mark. > > <!----------------//------ > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237043 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
