returning all matched values in calc element

[marozen]

In the calc element I have the following code to get a matching value from another table:

$db = FabrikWorker::getDbo($loadJoomlaDb = false, $cnnId = 3);
$query = $db->getQuery(true);
$query->select('description1')->from('plantspecies_photo1detail')
->where('plantid1 ='. (int) '{photo_names___id}')
$db->setQuery($query);
$results = $db->loadResult();
return $results;

The output is 1 "description1" from "photo1detail", but there are more records that match.
How can I return all of them?

 

[troester]

http://fabrikar.com/forums/index.php?wiki/php-common-tasks/#select

 

[marozen]

http://fabrikar.com/forums/index.php?wiki/php-common-tasks/#select

Thanks,

 

[cheesegrits]

https://docs.joomla.org/Selecting_data_using_JDatabase#Multi-Row_Results

-- hugh