it didn't give me any error, simiply as nothing changed
actually, I'm trying a different approch right here..
Table Name: Products
idProducts | Make1 | Model1 | Make2 | Model2 | Make3 | Model3
3 3 240SX 3 300ZX 3 350Z
4 3 300ZX
5 2 Supra 3 300ZX 1 Civic
============================================================ ===
Table Name: Makes
idMake | Make |
1 Honda
2 Toyota
3 Nissan
============================================================ ===
This is the way how the table was setup.
I want to make a search form that does 2 select pull down list
1.One select pull donw list shows all the "Make" from talbe "Makes" in acs
2.The other select pull down list shows all the "model1" + "model2" + "model3"
with no duplicate value in the list
I tried to do this one, but I can only get the model select list to show up 1 field,
and the value in the select list shows duplicated value.
Both select lists are chained.
When one make is selected, only car models under that particular make will show in
the model pull down list.
And, search script that does the search like
when I choose Toyota then Supra in the search from, it will go throught all the
products and search for products with "Supra" in any of the "model1", "model2",
or "model3" fields.
any help would be great. Thanks in advance!!