You are here: Re: selectbox dynamic range options « PHP Programming Language « IT news, forums, messages
Re: selectbox dynamic range options

Posted by Poppitypop on 08/14/07 23:26

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация