???
Hi,
I have a problem with creating a form where two elements are dropdowntables. They are limited by a join to an other table. They have to show a column from that other table as possible options. The only rows that need to be shown are the rows that are added to that table by the current logged in user. This is saved in the vriendboerid column of the other table.
I'm using Joomla 1.0.12 - fabrik1[1].0.4_upgrade_from_1.0.x--07-06-2007.zip (started with 1.0.3) on Windows.
I don't know the PHP and MySQL versions.
What did I do:
- Created the element
- Element type: Database join
- Render join as dropdown list
- Selected the correct database, table, keycolumn and value column
- and added the SQL where statement: where vriendboerid='{$my->id}' (also tried: where vriendboerid={$my->id})
- But I don't get any results. (With the quotes I get an empty list, without the quotes I get an error message)
- vriendboerid contains the userid of the users who created that row.
What an I doing wrong?
Hi,
I have a problem with creating a form where two elements are dropdowntables. They are limited by a join to an other table. They have to show a column from that other table as possible options. The only rows that need to be shown are the rows that are added to that table by the current logged in user. This is saved in the vriendboerid column of the other table.
I'm using Joomla 1.0.12 - fabrik1[1].0.4_upgrade_from_1.0.x--07-06-2007.zip (started with 1.0.3) on Windows.
I don't know the PHP and MySQL versions.
What did I do:
- Created the element
- Element type: Database join
- Render join as dropdown list
- Selected the correct database, table, keycolumn and value column
- and added the SQL where statement: where vriendboerid='{$my->id}' (also tried: where vriendboerid={$my->id})
- But I don't get any results. (With the quotes I get an empty list, without the quotes I get an error message)
- vriendboerid contains the userid of the users who created that row.
What an I doing wrong?