Click here to Skip to main content
15,917,991 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
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">
do {
?> <option value="<?php echo $row_sales['S_Date']?>">
<?php echo $row_sales['S_Date']?></option>
} 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!
Preston88 12-Mar-14 20:41pm    
Is it feasible if I use case to assign the data in attributes to retrieve for the different report? Im sorry. Really new to this.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900