<?php
/**
 *
 *
 * @package openmairie_exemple
 * @version SVN : $Id$
 */

require_once "../obj/utils.class.php";
$f = new utils("nohtml");
$f->disableLog();
/**
 *
 */
//header('Content-type: text/html; charset=iso-8859-1');
/**
 *
 */
$tab = $_POST["tab"];
$parent = $_POST["parent"];
$key = $_POST["key"];
/**
 *
 */
//
$sql = "SELECT * FROM ".DB_PREFIXE.$tab." WHERE ".$parent."=".$key; // ***
$res=$f->db->query($sql);
$f->isDatabaseError($res);
//
echo 'var o = null;';
echo 'var s = document.getElementById("'.$tab.'");';
echo 's.options.length = 0;';
if ($res->numRows() == 0) {
    echo 's.options[s.options.length] = new Option("Aucun(e) '.$tab.'","");';
} else {
    echo 's.options[s.options.length] = new Option("Choisir '.$tab.'","");';
    while ($row =& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
        echo 's.options[s.options.length] = new Option("'.$row[$tab.'lib'].'","'.$row[$tab].'");';
    }
}
//
$res->free();

?>