Custom code After Save

[sultan87]

hello,
the code in after-save is not performed

Code: Select all

nuDebug("Après Sauvegarde Séjours Locataires");

// Recherche id_locataire dans table suivi

nuDebug("Recherche Numéro Locataires");

$s = "

SELECT s_id_locataire 
FROM suivi 
WHERE id_suivi = '1'

";

$t = nuRunQuery($s);
$r = db_fetch_row($t);
$p = $r[0];

// MAJ id_locataire dans table sejours

$s = "

UPDATE sejours 
SET id_locataire_sejour =  '$p' 
WHERE id_sejours = '#RECORD_ID#'

";

why ?
Best regards
pierre

[admin]

sultan87,

I don't understand your question.

Steven

[mobilemcclintic]

I think you need to tell nuBuilder what to do.

Just reading the last bit,you set $s, but don't do anything with it.
Add nuRunQuery($s); to the end. If everything else is right, it should perform your update.