RE: [PHP] sample or tutorial for conditional pulldown menus
| From: | Maxim Maletsky | Date: | Wed, 08 Aug 2001 01:19:22 +0000 |
| Subject: | RE: [PHP] sample or tutorial for conditional pulldown menus | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-61729@lists.php.net to get a copy of this message | ||
Stop searching, just make it on your own.
have a model database :
table models:
id | make | model | submodel | year
then do :
select make from models group by make
below have the date range (can be static, since where it all began to the
current year)
then when make and year was selected :
select model from models where make='$make' and year='$year' group
by model
after this was selected do :
select submodel from models where make='$make' and year='$year' and
model='$model'
then check if found at least one row do the fourth pull down submodel menu,
otherwise "give it a go" - load the page related to the current car.
Use your fantasy to extend all this to suit your needs.
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
maxim@phpbeginner.com
www.phpbeginner.com
-----Original Message-----
From: Tom Beidler [mailto:tom@orbittechservices.com]
Sent: Wednesday, August 08, 2001 9:10 AM
To: php list
Subject: [PHP] sample or tutorial for conditional pulldown menus
I have a client that would like to duplicate something they've seen on one
of their competitor's web sites. It's for an automotive parts supplier and
they would like to build a search engine for different make, model, and year
applications. Since a picture is worth a thousand words here's a url to see
the site they would like to knock off;
http://www.performanceproducts.com/shopper_profile.asp?mscssid=2K5UHTRR3UV28
MLG468UVDQR3F4T73P3
They like that you could choose a year and a make, which jumps to a new page
with an additional pulldown menu for models associated with the selected
year and make. Some models even ask for a submodel. It's pretty cool but
it's in ASP and ssssllllllloooooooowwwwwww.
I was checking out Hotscripts and Devshed but didn't have any luck. Any info
would be greatly appreciated.
Thanks,
Tom
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net