i have two list boxes, depending on the values selected from the list boxes, i want to execute the query on a mysql table.
for eg:- one list box contains car brands(like tata, toyota) and another one contains car model (Indica, Innova)
If user selects a brand tata and model Indica then in one of the text field I want to fetch the records from the table which can give me commission
Any help is apprecieted
When the user clicks submit send the selected brand and model to a php script which runs a query something like
$query = 'select commission from someTable where colBrand = "'.$brand.'" and model = "'.$model.'"';
Make sure you sanitise the user inputs using either mysql_real_escape_string or prepared statements.