DBMultirecord Loader

sara79t 04 Jul, 2012
Hello my name is Sara and I am a new member of the forum.
I'm ssing ChronoForms v4 and Joomla 2.5.5 for a few months and I found a problem: I'm trying to organize a sort of manager registrations for events of an organization of birds's breeders.
I created the tables for the user registry to the organization("anagrafica"), data for birds ("uccelli") and a table for entry to the event in which are stored on the user cf_id, bird cf_id and price of bird. I want to load data from tables "anagrafica" and "uccelli" using the code stored on table "iscrizioni".
I tried to do following what "admin" said in this post http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=26&t=22242 but data are not loaded into the array; using debugger event the array is empty..
Max_admin 06 Jul, 2012
Hi Sara,

Welcome to the forums.

Can you write a working SQL statement for your tables ? if you can then this may help us find the correct actions combinations, right now I can't understand the relations between your tables clearly.

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
sara79t 11 Jul, 2012
Thanks for the reply admin. I noticed that did not work because I had "forgotten" to create relationships between tables. I created directly with phpmyadmin. Now the array is filled (seen by the debugger) but I can not render the results, what should I post to make you understand?

Data Array: 
Array
(
    [option] => com_chronoforms
    [chronoform] => selezioneISCR
    [Itemid] => 
    [iscritti] => Array
        (
            [0] => Array
                (
                    [cf_id] => 1
                    [cf_uid] => e7ffb4f51c0705117af1803121cde289
                    [cf_created] => 2012-06-15 17:59:44
                    [cf_modified] => 
                    [cf_ipaddress] => ::1
                    [cf_user_id] => 0
                    [an_cfid] => 1
                    [uc_cfid] => 0
                    [prezzo] =>  
                    [anagrafica] => Array
                        (
                            [0] => Array
                                (
                                    [cf_id] => 1
                                    [rna] => AE83
                                )

                        )

                )

            [1] => Array
                (
                    [cf_id] => 3
                    [cf_uid] => 02bbe6ecd610be45127790a444fc6456
                    [cf_created] => 2012-06-15 19:46:04
                    [cf_modified] => 
                    [cf_ipaddress] => ::1
                    [cf_user_id] => 0
                    [an_cfid] => 3
                    [uc_cfid] => 1
                    [prezzo] =>  
                    [anagrafica] => Array
                        (
                            [0] => Array
                                (
                                    [cf_id] => 3
                                    [rna] => 85MU
                                )

                        )

                )

            [2] => Array
                (
                    [cf_id] => 9
                    [cf_uid] => 1887998c64b4cc61fca0a093d8c129c5
                    [cf_created] => 2012-07-09 09:38:53
                    [cf_modified] => 
                    [cf_ipaddress] => ::1
                    [cf_user_id] => 0
                    [an_cfid] => 4
                    [uc_cfid] => 2
                    [prezzo] => 9
                    [anagrafica] => Array
                        (
                            [0] => Array
                                (
                                    [cf_id] => 4
                                    [rna] => 35FU
                                )

                        )

                )

        )

)
Validation Errors: 
Array
(
)
Debug Data
db_multi_record_loader
SELECT `iscritti`.*, `anagrafica`.`cf_id` AS `anagrafica.cf_id`, `anagrafica`.`rna` AS `anagrafica.rna` FROM `hnr01_chronoforms_data_iscrizioni` AS `iscritti` INNER JOIN `hnr01_chronoforms_data_anagrafica_clienti2` AS `anagrafica` WHERE anagrafica.cf_id=iscritti.an_cfid GROUP BY an_cfid
This topic is locked and no more replies can be posted.