static function get_option($selectedvalue, $tablename="pays", $colvaluename="id", $colvuename="nom", $where=1) { $option = ""; $result = CTable::select($colvaluename . " , " . $colvuename, $tablename, $where, $colvuename); while($array = mysql_fetch_array($result)) { $selected = CForm::get_selected($selectedvalue, $array[$colvaluename]); $option = $option . "<option value='" . $array[$colvaluename] . "'" . $selected . ">" . ucfirst(utf8_encode(substr($array[$colvuename], 0, 25))) . "</option>\n"; } return $option; }
static function get_option($selectedvalue, $tablename, $colvaluename="id", $colvuename="nom", $where=1, $order = null) { $option = ""; if(!$order) { $order = $colvuename; } $result = CTable::select($colvaluename . " , " . $colvuename, $tablename, $where, $order); while($array = mysql_fetch_array($result)) { $selected = CForm::get_selected($selectedvalue, $array[$colvaluename]); $option = $option . "<option value='" . $array[$colvaluename] . "'" . $selected . ">" . $array[$colvuename] . "</option>\n"; } return $option; }
static function fetchAll($select="*", $where="1", $order="mlt_zMail, mlt_zDateCreation") { $oRes = parent::select($select, 'moul_tables', $where, COrder::formate($order)); $toResults = array() ; if ($oRes){ while ($toRes = mysql_fetch_assoc($oRes)){ $toResults[] = $toRes ; } } return $toResults ; }
static function select($select="*", $where="1", $order="rang") { return parent::select($select, 'categorie_user', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="id") { return parent::select($select, 'image', $where, COrder::formate($order)); }
static function select($select="*", $where, $order="id") { if(empty($order)) $order = "id"; return parent::select($select, 'rdvContact', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="id") { if(empty($order)) $order = "id"; // return parent::select($select, 'gr_rdv_user', $where, COrder::formate($order)); return parent::select($select, 'gr_rdv', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="rang") { return parent::select($select, 'domaine', $where, $order="rang"); }
static function select($select="*", $where="1", $order="nomart, rang") { return parent::select($select, 'page_art', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="nom") { return parent::select($select, 'departement', $where, $order); }
static function select($select="*", $where="id_campagne < 1", $order="id") { return parent::select($select, 'gr_email', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="id") { return parent::select($select, 'opportuniteContact', $where, $order); }
static function select($select="*", $where="1", $order="rang") { return parent::select($select, 'article_cat', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="id") { return parent::select($select, 'groupeUtilitaire', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="nom_com"){ return parent::select($select, 'commune', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="id desc") { if(empty($order)) $order = "id desc"; return parent::select($select, 'user', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="DESC") { if(empty($order)) $order = "DESC"; return parent::select($select, 'entreprise', $where, COrder::formate($order)); }
static function select($select="*", $where="1", $order="nom") { return parent::select($select, 'configuration', $where, $order="nom"); }