Forums

Create TWO Selection-lists from TWO DB-Tables in NEW CForm

touristin 23 Feb, 2012
hi there,
im looking for some HOWTO regarding how to do the following:

1) create a chronoform
2) with TWO select-lists of which one is a list of items and one is a list of boxes which are stored in TWO DIFFERENT DB-TABLES.
3) both - rooms and items - are to be selected by the user and then submitted to a third DB-Table.

i know how to create ONE <select>-input with all the options/values from ONE table-column using a chronoconnection.
AND i know quite well how to use chronoforms to store (and recall/edit) data.

what i don't know is how to get data from a table (or two tables) into a new chronoform e.g. as selection-list (i.e two selection-lists).

submitting and recording the results in a third DB-table is not a problem.

so it would be great if someone told me:
"hey - that's as easy as:
{chronoconnectivity}my_ITEMS_TBL{/chronoconnectivity}
 or 
{chronoconnectivity:Connectionname,tablename,ColName}

just add it to the form-html in the form-code-window!"

i know sql, javascript and how to install and manage plugins but don't want to do much php or even hack the joomla-installation...

help please!
GreyHead 23 Feb, 2012
Hi touristin ,

Just checking . . . this is a ChronoForms question? (you are posting in the ChronoConenctivity forum).

If so, which version of ChronoForms are you using? You can find the version from Site Admin | Extensions | Install/Uninstall | Components in Joomla! 1.5 or Site Admin | Extensions | Extension Manager | Manage in Joomla! 1.6/1.7/2.5.

Bob
touristin 08 Mar, 2012
Chronoconnectivity 2.0 RC3
Chronocontact V 3.2
Joomla 1.5 (.23 yet)

I use a few Chronoforms to handle any user-input on some Joomla 1.5 site.
Sorry if i hit the wrong forum...
This topic is locked and no more replies can be posted.