[PHP-DB] Re: Dynamic Drop Down Box

[Ralph Friedman]

In article , Randy Rankin wrote:
> Based on the user selection, the 2nd
> drop down box would be populated with the distinct 'make' for that model
> (ie; if the user selects Ford in the first drop down, the 2nd drop down
> would be populated with Explorer, Expedition, Ranger, etc.).
>

something like SELECT Model FROM MyTable WHERE Manufacturer='Ford'

-- 
Rgds
Ralph



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Dynamic Drop Down Box

[Aron Pilhofer]

So, if the user selects "mercedes", then the next box is "500Sl, 300Sc" and
so forth. If they select ford, then the second box has completely different
values?

You'll either have to reload the page after the first select, or use
javascript or some other kind of client script. I don't think there is a way
to do it with PHP, but maybe someone else has an idea to help you. I hope
they do, because I need to do the same sort of thing, and I am trying to
avoid js at all costs.



"Randy Rankin" <[EMAIL PROTECTED]> wrote in message
F3BF649E168BD411A1B700010271F38BB4BD20@SBMAIL">news:F3BF649E168BD411A1B700010271F38BB4BD20@SBMAIL...
> Does anyone know how I might populate a drop down box based on the users
> selection from a previous drop down box? For example, if I have a table
> called 'autos' with 2 fields, 'make' and 'model'. I select distinct 'make'
> and populate the first drop down box. Based on the user selection, the 2nd
> drop down box would be populated with the distinct 'make' for that model
> (ie; if the user selects Ford in the first drop down, the 2nd drop down
> would be populated with Explorer, Expedition, Ranger, etc.).
>
> Thanks,
>
> Randy Rankin
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Dynamic Drop Down Box

[fls]

I've got a dynamic dropdown on http://www.northjerseydirectories.com
I generate the js using php and a MySQL database.  The dropdown does what
you're looking for.  Since the dropdown is client side you either need to
go with javascript, an applet, or have the person submit a form that loads
the second box which is pretty clumsy.
Fred Steinkopf

On Wed, 6 Mar 2002, Aron Pilhofer wrote:

> So, if the user selects "mercedes", then the next box is "500Sl, 300Sc" and
> so forth. If they select ford, then the second box has completely different
> values?
>
> You'll either have to reload the page after the first select, or use
> javascript or some other kind of client script. I don't think there is a way
> to do it with PHP, but maybe someone else has an idea to help you. I hope
> they do, because I need to do the same sort of thing, and I am trying to
> avoid js at all costs.
>
>
>
> "Randy Rankin" <[EMAIL PROTECTED]> wrote in message
> F3BF649E168BD411A1B700010271F38BB4BD20@SBMAIL">news:F3BF649E168BD411A1B700010271F38BB4BD20@SBMAIL...
> > Does anyone know how I might populate a drop down box based on the users
> > selection from a previous drop down box? For example, if I have a table
> > called 'autos' with 2 fields, 'make' and 'model'. I select distinct 'make'
> > and populate the first drop down box. Based on the user selection, the 2nd
> > drop down box would be populated with the distinct 'make' for that model
> > (ie; if the user selects Ford in the first drop down, the 2nd drop down
> > would be populated with Explorer, Expedition, Ranger, etc.).
> >
> > Thanks,
> >
> > Randy Rankin
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Dynamic Drop Down Box

[Bill Morrow]

I haven't actually tried this, but if you use frames, could you submit
from the first dropdown and refresh the second if they are in seperate frames?

Not that I'd like to support that code.

On Wed, Mar 06, 2002 at 10:14:59AM -0800, fls wrote:
> I've got a dynamic dropdown on http://www.northjerseydirectories.com
> I generate the js using php and a MySQL database.  The dropdown does what
> you're looking for.  Since the dropdown is client side you either need to
> go with javascript, an applet, or have the person submit a form that loads
> the second box which is pretty clumsy.
> Fred Steinkopf
> 
> On Wed, 6 Mar 2002, Aron Pilhofer wrote:
> 
> > So, if the user selects "mercedes", then the next box is "500Sl, 300Sc" and
> > so forth. If they select ford, then the second box has completely different
> > values?
> >
> > You'll either have to reload the page after the first select, or use
> > javascript or some other kind of client script. I don't think there is a way
> > to do it with PHP, but maybe someone else has an idea to help you. I hope
> > they do, because I need to do the same sort of thing, and I am trying to
> > avoid js at all costs.
> >
> >
> >
> > "Randy Rankin" <[EMAIL PROTECTED]> wrote in message
> > F3BF649E168BD411A1B700010271F38BB4BD20@SBMAIL">news:F3BF649E168BD411A1B700010271F38BB4BD20@SBMAIL...
> > > Does anyone know how I might populate a drop down box based on the users
> > > selection from a previous drop down box? For example, if I have a table
> > > called 'autos' with 2 fields, 'make' and 'model'. I select distinct 'make'
> > > and populate the first drop down box. Based on the user selection, the 2nd
> > > drop down box would be populated with the distinct 'make' for that model
> > > (ie; if the user selects Ford in the first drop down, the 2nd drop down
> > > would be populated with Explorer, Expedition, Ranger, etc.).
> > >
> > > Thanks,
> > >
> > > Randy Rankin
> > >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php