https://interactivetools.com/forum/forum-posts.php?Using-the-List-box-with-MySQL-70029 Tue, 14 Jul 2026 08:21:48 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2197386#post2197386
Thanks for those screens! I think I see what you are doing here. Basically, it's going to be really difficult to get those drop down values changing in the admin interface.

What we could do though is setup a custom script for you that is basically the exact same thing (a form that lets you add records to the database) but because it isn't in the main admin interface, we have the code to handle those drop downs.

Because it would be a custom job, we'll need to go through consulting@interactivetools.com. Drop me and email and we'll go over it in more detail.

Thanks!
]]> Fri, 15 May 2009 12:46:13 -0700 forum-posts.php?postNum=2197386#post2197386 https://interactivetools.com/forum/forum-posts.php?postNum=2197342#post2197342
This might end up being more than we can handle in a forum post but for the time being, could you put up a link to the page you are working on with this? I'd like to see have you have it setup so far,

Thanks :)
]]> Wed, 13 May 2009 12:21:00 -0700 forum-posts.php?postNum=2197342#post2197342 https://interactivetools.com/forum/forum-posts.php?postNum=2197329#post2197329 Ok maybe I need another type of example there are a few areas in which I need to do this so maybe giving another example maybe easier.

Ok I have a table called: equipment type this has the fields: make, model and type

[img]http://www.vixsoft.com/helpmeplease/equipment-type.jpg[/img]

make is the manufacture e.g. ZyXEL, Cisco or HP etc. Model is the actual model number and type is what the item is e.g. Router, Firewall, Server etc.

ok so let’s say I add:
make = cisco
model = 877
type = router


[font "Calibri"][img]http://www.vixsoft.com/helpmeplease/equipmenttypeoptions.jpg[/img]



next section:

I have a table called clients_equipment I have added 3 list box’s based on the fields from the table above (equipment_type)

what I want to be able to do is select type and then make and for the list for make to dynamically update to only display items that have router in the type and then for the model list box to update to only show the items that have both the make and type matching

[font "Calibri"]e.g. I select Router from the type list box and the list box will then display ZyXEL and Cisco (as they have been set with Router in the field: type in the table equipment_type) I select Cisco from the make list box (as this has been set in the make field within the table equipment_type) and then the model should only display 877

Type > Make > Model
Router > Cisco > 877

Type > Make > Model
Firewall > ZyXEL > USG100, USG200, USG300


[img]http://www.vixsoft.com/helpmeplease/clientsequipment.jpg[/img]


Hope this is clearer than before. somtimes its very difficult to discribe what you are trying to achive.

Many thanks kevin
]]> Wed, 13 May 2009 11:07:39 -0700 forum-posts.php?postNum=2197329#post2197329 https://interactivetools.com/forum/forum-posts.php?postNum=2197321#post2197321
I think I'm going to need some more details on this one.

>how do I get the branch box to query the database and only display the braches listed with the same client name (from field client name) ?

Are talking about when you are entering records in the Fullinfo section?

Also, are you wanting to choose an clients name, from the dropdown list, and then have the Branch dropdown dynamically update to show only branch with that client?

Can give some examples? Even with made up data would hopefully help make it more clear how this should work.

Sorry, I'm just having trouble getting my head wrapped around what you are after.
]]> Tue, 12 May 2009 17:33:47 -0700 forum-posts.php?postNum=2197321#post2197321 https://interactivetools.com/forum/forum-posts.php?postNum=2197285#post2197285 I have then created another table called ‘fullinfo’ I have created a list box based on the field ‘client_name’ and I have created another list box based on ‘branch’

how do I get the branch box to query the database and only display the braches listed with the same client name (from field client name) ?

should be an easy one I would say but I must be looking at this all the wrong way

If anyone has any ideas

Cheers
]]> Sun, 10 May 2009 13:48:27 -0700 forum-posts.php?postNum=2197285#post2197285