leblancphil
Member
Hi
I try to build a calc element with that query
That works in phpMyAdmin, replacing $scol_id by the right value
When I test
Ok, I have my value
I do this in my calc element ( and tried many other ways) but no result.
Could you help please ?
Thanks
I try to build a calc element with that query
Code:
SELECT SUM(prix_parcours) FROM admin3_parcours , admin3_scol_parcours WHERE admin3_parcours.id = admin3_scol_parcours.parours_id AND admin3_scol_parcours.scol_id = $scol_id
When I test
Code:
$scol_id = '{admin3_scolarites___id}';
return $scol_id;
I do this in my calc element ( and tried many other ways) but no result.
Code:
$scol_id = '{admin3_scolarites___id}';
$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery->select('SUM(prix_parcours)')->from('admin3_parcours', 'admin3_scol_parcours')->where('admin3_parcours.id' = 'admin3_scol_parcours.parours_id' AND 'admin3_scol_parcours.scol_id' = $scol_id);
$myDb->setQuery($myQuery);
$devis = $myDb->loadResult();
return $devis;
Thanks