I have a 3 link select

Make Model Year


[www.qualitypowerauto.com]


We're finding folks pick Make / Model and then hit submit (maybe they are hoping to get all the years ?) .. but instead they get nothing.

Is there a way to force them to pick all three - or at least to default to something else if they don't pick ?

Thanks

Donna

Hi,
this is up to your search script, if user let "Please select" option then you will get a 0 as selected id.
So you have Make=make12 Model=model235 and Year=0. What you need is to check $_POST['Year'] if is 0 to exclude that field from where clause,
select * from spare_parts where make='make12' and model='model235'
instead of quering
select * from spare_parts where make='make12' and model='model235' and year=0

that's what i think