131 Posts
layonill
4 years ago
3
Topic

hi, I have 2 select dynamics, the first one called OBRA brings me a list of subcategories created by the current log in user and from a specific parent category, this one is ok, the second called ANUNCIO brings me an html text, now, I want ANUNCIO to bring me the text based on the value selected in OBRA, so OBRA can filter ANUNCIO

the query in each ares these

OBRA: SELECT title as text, id as value FROM #__categories WHERE created_user_id = $user->id AND parent_id=8

ANUNCIO: SELECT anuncio_en_comic as text, id as value FROM #__cck_store_form_nuevo_comic

I need to complete the query in ANUNCIO so it brings me the value based on OBRA, what they have in common is the subcategory id, so I want to see how to do this


Get a VIP membership
1283 Posts
Bucklash
4 years ago
2
Level 1

select dynamic cascade does that sort of thing  

131 Posts
layonill
4 years ago
1
Level 2

is there another way?

4229 Posts
Kadministrator
4 years ago
0
Level 3

Yes, you can display all results in second select dynamic, than filter them down based on first fields value using client side javascript, but you will have to implement that by yourself, you can see an example of such implementation in the location dropdowns (first 2 selects on the left) here https://belmondo.si

Get a Book for SEBLOD