need num of related record in checkboxk field
3 posts by 2 authors in: Forums > CMS Builder
Last Post: September 14, 2012 (RSS)
For what I need to do (shown below), I would like to know if it suggested to use the beta Lookup Related Records plugin or not. I've tried with and without the plugin and have not had success.
What I want to do...
The 'workshops' table allows the choice of multiple names from a 'presenter' checkbox list field (showing options from the 'workshop_presenters' table, using 'num' for values).
For each 'presenter' chosen for a workshop, I need to display the associated record 'num' from the 'workshop_presenters' table like this:
Mary Jones 11
Joe Smith 32
Sam Williams 44
Using the Lookup Related Records plugin I receive an error which according to an older forum post might be due to the checkboxes for the list field:
"Warning: explode() expects parameter 2 to be string..."
Without the plugin I can display a list of separated 'presenter' names, but can't bring in the associated 'num' for each from the related table.
If I know which direction (with or without plugin) is recommended I can then post my non-working code and be more specific with my questions.
Thanks in advance for any help.
Deborah
What I want to do...
The 'workshops' table allows the choice of multiple names from a 'presenter' checkbox list field (showing options from the 'workshop_presenters' table, using 'num' for values).
For each 'presenter' chosen for a workshop, I need to display the associated record 'num' from the 'workshop_presenters' table like this:
Mary Jones 11
Joe Smith 32
Sam Williams 44
Using the Lookup Related Records plugin I receive an error which according to an older forum post might be due to the checkboxes for the list field:
"Warning: explode() expects parameter 2 to be string..."
Without the plugin I can display a list of separated 'presenter' names, but can't bring in the associated 'num' for each from the related table.
If I know which direction (with or without plugin) is recommended I can then post my non-working code and be more specific with my questions.
Thanks in advance for any help.
Deborah
Re: [Deborah] need num of related record in checkboxk field
Hi Deborah,
I think you can get this data fairly easily without having to use the related records plugin. You could try doing something like this:
Although you might have to do a slightly more complex query if your looking to get more data on each presenter than this. But even then I think it would be simpler to write the code to do it than to use the related records plugin.
Thanks!
I think you can get this data fairly easily without having to use the related records plugin. You could try doing something like this:
// load record from 'category'
list($workshopsRecords, $workshopsMetaData) = getRecords(array(
'tableName' => 'workshops',
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$workshopRecord = @$workshopsRecords[0]; // get first record
if (!$workshopRecord) { dieWith404("Record not found!"); } // show error message if no record found
$listOfPresenters = array_combine($workshopRecord['workshop_presenters:values'],$workshopRecord['workshop_presenters:labels']);
foreach($listOfPresenters as $key => $item){
echo $item." ".$key;
}Although you might have to do a slightly more complex query if your looking to get more data on each presenter than this. But even then I think it would be simpler to write the code to do it than to use the related records plugin.
Thanks!
Greg Thomas
PHP Programmer - interactivetools.com
PHP Programmer - interactivetools.com
Re: [greg] need num of related record in checkbox field
Greg,
Thanks so much for the suggestion. I wasn't ablel to get the code working for me. I'll move on to 'Plan B', but wanted to say "thanks".
~ Deborah
Thanks so much for the suggestion. I wasn't ablel to get the code working for me. I'll move on to 'Plan B', but wanted to say "thanks".
~ Deborah