I have two list boxes, depending on the values selected from the list boxes

Hi

all

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

Thanks
MD.Samiuddin

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 [fphp]mysql_real_escape_string[/fphp] or prepared statements.