start with this andy, and you can filter out the ones you dont want because
they are too low, or too high based on the search value?
<cfloop from = 1 to = 1000000 step = 25000 index = i>
<option value="#i#">i
</cfloop>
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:237047
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
