query($query); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $res[] = $row; } return $res; } return null; } function get_list(){ global $DB; $query = "SELECT en.id_entete,en.fonction ,en.num,en.date,en.type , concat(glpi_users.realname,' ',glpi_users.firstname) as fullname FROM decharge_entete as en LEFT JOIN glpi_users on en.id_user = glpi_users.id ORDER BY `en`.`id_entete` DESC"; $result = $DB->query($query); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $res[] = $row; } return $res; } return null; } $res =get_list() ; echo '
| Utilisateur | N° | Type | date | |
|---|---|---|---|---|