php variable un sql query

Hello,
Don't know if CC bug or myself mistake :

This work in a chronoform (after submitting mail):

<?php
$db =& JFactory::getDBO();
$nv_stage=$_POST['stage'];
$requete_get_maquette = 'SELECT urgences,chu,med_adulte,pedia_gyneco FROM jos_liste_stage_hospit WHERE stage="'.$nv_stage.'"';
$db->setQuery($requete_get_maquette);
$liste = $db->loadObjectList();

$le_stage = $liste[0];
echo "urg : $le_stage->urgences ";
echo "ma : $le_stage->med_adulte ";
echo "chu : $le_stage->chu ";
echo "peda_gyneco : $le_stage->pedia_gyneco ";
?>

and give me :

urg : 0 ma : 1 chu : 1 peda_gyneco : 0

But in CConnectivity I get stage not from POST but from context with {} so I change

$nv_stage=$_POST['stage'];

with

$nv_stage="{stage}";

But finely this fails et and retruns :

urg : ma : chu : peda_gyneco :

If I change "'.$nv_stage.'" with "some_const" this works !!!

I thought it was in query but

echo $db->getQuery();

returns same thing for "'.$nv_stage.'" or "some_const" :

SELECT urgences,chu,med_adulte,pedia_gyneco FROM jos_liste_stage_hospit WHERE stage="some const"

do you have some idea ?
thanks

PS : I use DB request in CConnectivity because I use data from another table that the connection use.

Hi,

that's because the code is evaluated (and so PHP is executed" before the replacement is done, instead use $row->stage

regards
Max

first thank you for your answer.

Ichanged

$nv_stage="{stage}";

with

 $nv_stage=$row->stage;

but it doesn't change anything. Did you mean that ?

Hi, thank you, tha's what I mean yes, it will work only in the "body" box code, did you try this ?

Max

come back from week-end and it works !!!

thanks lot your solution were the good one, don't known what I did last week ....

No problems!🙂

Max