calc element sum

[leblancphil]

Hi
I try to build a calc element with that query

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

That works in phpMyAdmin, replacing $scol_id by the right value

When I test

$scol_id = '{admin3_scolarites___id}';
return $scol_id;

Ok, I have my value

I do this in my calc element ( and tried many other ways) but no result.

$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;

Could you help please ?
Thanks

 

[troester]

Try _id_raw
ah, and inside where() you must have a string

Gesendet von meinem GT-I9300 mit Tapatalk

 

[leblancphil]

Thanks for your answer, it's not a id_raw pb, I have tested and I dont understand how to organise where() to have a string.

 

[troester]

->where('admin3_parcours.id' = 'admin3_scol_parcours.parours_id' AND 'admin3_scol_parcours.scol_id' = $scol_id)

Must be something like
->where('admin3_parcours.id = admin3_scol_parcours.parours_id AND admin3_scol_parcours.scol_id = '. $scol_id)

for debugging add
echo $myQuery;exit;
before return

 

[leblancphil]

Works fine
Thank youuuuuuuuuuuuouuuuuuuuuuuouuuuuuuuuuuuuu