JackGoa
Member
Hi. I'm creating a form with one element. The element is a dropdown database join.
I'm populating it with categories.
I've managed to get the category titles to display in the dropdown.
I'm using this:
as my SQL statement.
Then I have a redirect jump URL like this:
index.php?option=com_content&view=category&layout=blog&id={___select_project}
On submission, I end up with a 404 error and in the URL I get this:
index.php?option=com_content&view=category&layout=blog&id=Work%20with%20children&isMambot=1
It seems like my dropdown select returns the title of the category instead of the ID.
Any ideas?
And while on the subject, how can I submit the form once a user selects an option without having to click "submit"?
Joomla 3.3.6
Fabrik 3.2 (about to upload the freshest Github copy)
I'm populating it with categories.
I've managed to get the category titles to display in the dropdown.
I'm using this:
Code:
WHERE {thistable}.`title`
IN ( SELECT sifds_categories.title FROM sifds_categories
WHERE sifds_categories.parent_id = 87)
Then I have a redirect jump URL like this:
index.php?option=com_content&view=category&layout=blog&id={___select_project}
On submission, I end up with a 404 error and in the URL I get this:
index.php?option=com_content&view=category&layout=blog&id=Work%20with%20children&isMambot=1
It seems like my dropdown select returns the title of the category instead of the ID.
Any ideas?
And while on the subject, how can I submit the form once a user selects an option without having to click "submit"?
Joomla 3.3.6
Fabrik 3.2 (about to upload the freshest Github copy)