function maxClassement($idcaracteristique, $lang) { $caracdispdesc = new Caracdispdesc(); $caracdisp = new Caracdisp(); $query = "\n\t\t\tselect\n\t\t\t\tmax(ddd.classement) as maxClassement\n\t\t\tfrom\n\t\t\t\t{$caracdispdesc->table} ddd\n\t\t\tleft join\n\t\t\t\t{$caracdisp->table} dd on dd.id = ddd.caracdisp\n\t\t\twhere\n\t\t\t\tlang={$lang}\n\t\t\tand\n\t\t\t\tdd.caracteristique={$idcaracteristique}\n\t\t"; $resul = $caracdispdesc->query($query); return $resul ? intval($caracdispdesc->get_result($resul, 0, "maxClassement")) : 0; }
public function getMaxCaracdispRank($idcaracteristique, $lang) { $caracdispdesc = new Caracdispdesc(); $caracdisp = new Caracdisp(); $query = "\n select\n max(ddd.classement) as maxClassement\n from\n {$caracdispdesc->table} ddd\n left join\n {$caracdisp->table} dd on dd.id = ddd.caracdisp\n where\n lang={$lang}\n and\n dd.caracteristique={$idcaracteristique}\n "; $resul = $caracdispdesc->query($query); return $resul ? intval($caracdispdesc->get_result($resul, 0, "maxClassement")) : 0; }