i have a processreport.php that will retrieve data from the database and user input from salesreport.php. For example; when the user choose to view sales by category and clicked the submit button in salesreport.php, a chart with category name and sales will be displayed in processreport.php. How am i going to make the processreport.php retrieve new data from the database and displayed it.


i displayed a chart in processreport.php. i want the form to retrive new data and displayed the new chart when the user clicked the drill down button which is next to it.but how to do it?
i tried by <input type="button" name="drilldown" value="Drill down" onclick="function drill()"> and in the
function drill() {
retrieve data...
display data..
}

but it doesn't work. Please advice me how to display new retrieved data on the same page?