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..
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..
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
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
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.