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

[samiuddin.adse]

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

[aidos]

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.