![]() |
Admin 1/11/2011 |
It's not about what PHPRunner supports. You won't be able to handle unlimited recursive categories in a single SQL query. |
K
|
komlos author 1/11/2011 |
I know that article. You are right, but I could use SQL queries in nested while loops in PHP, and that can be unlimited. I've done that a couple of times. I was actually thinking about this solution somehow integrated in events. Though your simple solution looks quite promising, but please give me some clarification. |
![]() |
Admin 1/12/2011 |
I would suggest to add category, subcategory1, subcategory2, subcategory3 fields to Ads table. It's not that difficult to replace all of them with a single category field and restore the whole path running a few SQL queries but having a dedicated field for each level is really the easiest way. |
K
|
komlos author 1/12/2011 |
I've tried your solution and it is quite simple to add dependent boxes if a subcategory belongs to only one parent category. Otherwise one have to follow your "BMW" workaround in your above tutorial.
|
![]() |
Admin 1/13/2011 |
|
K
|
komlos author 1/13/2011 |
|
![]() |
Admin 1/13/2011 |
Javascript API allows you to make field 'Required' or 'Not required' on the fly: |
K
|
komlos author 1/14/2011 |
Thanks I'll try that. How do I make this modification on the PHP side using events? |
![]() |
Admin 1/14/2011 |
To the best of my understanding - you need to handle all this on the client side using Javascript. |
K
|
komlos author 1/18/2011 |
I tried to use the "Path Enumeration Method" for storing 3 level of categories in one table like in the below example, but with this setup it is not possible to create the dependent dropdown boxes. |