[APuppyDog]

I have a script which adds to a database such as from, and to.

let's say I was in the marines from 1980 to 1990, when I enter it in the databse, i enter from 1980, to 1990

Then, I want a page to be able to search. But on this page, i just want one drop down with all the years from the database.. so in my database, i have a from_year, and a to_year colum in a table

is it possible to display a drop down with all the values from from_year, to to_year like this

1980
1981
...
...
...
2003
2004

[Eclipse]

Yea try this well this is the general idea

PHP Code:

$year1 = $_POST["year1"]; //lets says it's 2000

$year2 = $_POST["year2"]; //lets say it's 2004

$test = $year1;

while($test != $year2){

echo($test);

$test = ++$test;

} 

Then use a js function to make sure that the first one is larger than the second. Hope that helps...