PHP/MySQL jump menu

[fadeski]

Hi,

I've been trying endlessly to get a jump menu that displays a set or records.

I know how to create a jump menu, my problem is how do I display a record based on what's chosen in the menu? I know it seems simple, but it's my first time attempting this.

What I have is information in my database listed by date - 2004, 2003, 2002, etc. So in my menu it would be:
-2004
-2003
-2002

And when '2004' is clicked, the page will reload, showing only the results that are in the year 2004, etc...

How would I do this? Sorry if this seems too simple, I've been searching around and can't find anything on this, plus I'm still trying to learn PHP.

Thanks.

[devinemke]

here is a simplified example (no error checking)

<form action="" method="POST">
<select name="year">
<option>2004
<option>2003
<option>2002
<option>2001
<option>2000
</select><br>
<input type="submit" name="submit" value="submit">
</form>

<?
if (isset($_POST['submit']))
{
	mysql_connect('server', 'username', 'password');
	mysql_select_db('database');

$result = mysql_query("SELECT * FROM table WHERE YEAR(date) = '" . $_POST['year'] . "'");
echo '<pre>';
while ($row = mysql_fetch_assoc($result))
{
	print_r($row);
}
echo '</pre>';
}
?>

[fadeski]

Thanks for the reply.

I tried it and it works but it shows everything as an array.

Like this:

Array
(
    [ID] => 3
    [date] => 2004-04-01
    [name] => Jake
    [style] => None
)

I'm guessing it's in the query?