Dynamic Drop Down Menu

[nick.elliott10]

I have managed to write the code for a dynamic dropdown menu, as can be seen below.

PHP Code:

<?php
include("../../includes/db/connect.php");

$query = "SELECT * FROM `termdates`";
$result = mysql_query($query) or die(mysql_error());

$dropdown = "<select name='term'>";
while($row = mysql_fetch_assoc($result))
{
$dropdown .= "\r\n<option value='{$row['termID']}'>{$row['termText']}</option>";
}
$dropdown .= "\r\n</select>";
echo $dropdown;

mysql_close();
?>

However, depending on the value selected from the drop down menu, I need it to show the term dates for the year selected. Does any one have any suggestions?

Thank you for any help in advance.

[mlseim]

I don't understand question.
You're currently selecting everything without any conditions.
Somewhere before the query, you need to specify a year and then
create a condition in the query to only pull-out those rows that match the year.

I guess I don't see what "year selected" means?

[nick.elliott10]

I want it so that the user and select the academic year from the drop down menu, which is database driven and then it will query the database again and return the term dates for that academic year.

Basically, like this (http://www.cromwellcc.org.uk/about/t...s/Default.aspx) but in PHP/mySQL.

Thanks.

[myfayt]

Use Ajax for this, or Javascript.

[mlseim]

If it's OK to refresh the screen, you won't need AJAX, but if
you want it to be "fluid" changing, with a page refresh, you'll
need to use AJAX (PHP and Javascripting).