Retrieve and Display in different DIV based on selection chosen in drop down list

See more:

Javascript

SQL

PHP

database

hi
i have created a drop down list and retrieved and assign values in an attribute (S_Date) as the option:

<form method="post" name="sales">Year:
<select name="sales" id="sales">
<?php
do {
?> <option value="<?php echo $row_sales['S_Date']?>">
<?php echo $row_sales['S_Date']?></option>
<?php
} while ($row_sales = mysql_fetch_assoc($sales));
$rows = mysql_num_rows($sales);
if($rows > 0) {
mysql_data_seek($sales, 0);
$row_sales = mysql_fetch_assoc($sales);
}
?> </form>



May i know how to retrieve and display the filtered data in a div ("report_area") based on the year selected in the drop down list?

i'm trying to create different types of sales reports (which will retrieve values from different set of attributes from the db; report will be displayed in form of charts and so [using js]) where the links to them will appear in the respective <Div> based on the year selected in the drop down list. Anyone has come across any tutorial or so that might be useful to me? Thanks!