|
|
Posted by giloosh on 08/15/07 13:43
On Aug 14, 8:21 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> giloosh wrote:
> > On Aug 14, 7:26 pm, Poppitypop <poppity...@gmail.com> wrote:
> >> Ok, you do this
>
> >> 1.) you would pull the row with the largest price and the row with the
> >> smallest price. Ex:
> >> quarry 1.) SELECT price FROM table ORDER BY price ASC LIMIT 1
>
> >> quarry 2.) SELECT price FROM table ORDER BY price DESC LIMIT 1
>
> >> Those will return the highest and lowest prices.
>
> >> 2.) Subtract the lowest price from the highest price
> >> $result = $high-$low;
>
> >> 3.) divide that result by the amount of rages you want
> >> $num_ranges = 4;
> >> $range = $result/$num_ranges;
>
> >> 4.)the ranges are these
> >> for ($n = 0; $n < $num_ranges; $n++){
> >> echo $low+($range*$n);
> >> echo " - ";
> >> echo $low+($range*($n+1));
>
> >> }
>
> >> That should work. I know I didn't write the exact code. Sry
>
> > Thank you for your fast reply!
> > your idea is very clever and would absolutely work.
>
> > now this brings another concern. what if the selectbox displays
> > options that would return 0 results in the search if selected.
>
> > if all of the items in the table had prices of $500, $400, $150 and
> > $100 lets say.
> > the selectbox would display
>
> > 100 - 200
> > 200 - 300
> > 300 - 400
> > 400 - 500
>
> > if i chose 200 - 300, the query would return 0 results. there are no
> > items in the table with a price between 200-300.
>
> > How would i make this selectbox "smarter" in a way that it would only
> > display valid options?
>
> There you'll have to get all of the prices, sort them and figure out
> what your ranges should be.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================
Yea, makes sense. I would grab all of the prices and put them into one
array and do a bunch of sorting with the array. Could you please give
me an example of what kind of sorting i could do with the array of
prices? I am still a but stuck on that.
Thank you very much for your help!
Navigation:
[Reply to this message]
|