Issue with multi records from another table
4 posts by 2 authors in: Forums > CMS Builder
Last Post: April 5, 2010 (RSS)
By theclicklab - March 31, 2010 - edited: March 31, 2010
I have a field setup like this:
List (multi value)
Get options from database
Section Table Name: yachts
Use this field for option values: num
Use this field for option labels: yacht_name
In the template I have this to grab the multiple records:
<?php
// Gets list of yachts
$num2 = $nl_multiRecord['yachts'];
if (!$num2) { $num2 = 1; } // default num
list($yachtsRecords, $yachtsMetaData) = getRecords(array(
'tableName' => 'yachts',
'where' => "num LIKE '$num2'", //Gets multiple records
'allowSearch' => '0',
));
?>And this to print out details:
<?php foreach ($yachtsRecords as $record): ?>
Yacht Name: <?php echo $record['yacht_name'] ?><br/>
<?php endforeach ?>Any idea why I'm not getting any output? See attached.
Many Thanks!
Re: [aquaman] Issue with multi records from another table
By Chris - April 1, 2010
A "multi value" list field will contain, for example:
tab 1 tab 2 tab 3 tab
... which is represented in both PHP and MySQL as:
"\t1\t2\t3\t"
So, to get the records listed there, you'd need to change that to a comma-separated list, then use MySQL's "IN" operator:
$numsTabbedList = $nl_multiRecord['yachts'];
$numsTabbedList = trim($numsTabbedList);
$numsCommaList = str_replace("\t", ",", $numsTabbedList);
if ($numsCommaList) {
list($yachtsRecords,) = getRecords(array(
'tableName' => 'yachts',
'where' => "num IN ($numsCommaList)",
'allowSearch' => '0',
));
}
else {
$yachtsRecords = array(); // empty array
}I hope this helps. Please let me know if you have any questions.
Chris
Re: [chris] Issue with multi records from another table
By theclicklab - April 4, 2010
Re: [aquaman] Issue with multi records from another table
By Chris - April 5, 2010
Glad I could help! :)
Chris