83,7 → 83,7 |
|
// si une lettre est selectionne |
if (!empty($_REQUEST['lettre'])) { |
$requete = "SELECT ".ANN_ANNUAIRE.".* from ".ANN_ANNUAIRE." WHERE"; |
$requete = "SELECT ".ANN_ANNUAIRE.".*, ".ANN_TABLE_PAYS.".* FROM ".ANN_ANNUAIRE.",".ANN_TABLE_PAYS." WHERE ".ANN_CHAMPS_PAYS." = ".ANN_GC_ID." AND "; |
if ($_REQUEST['lettre'] != "tous") $requete .= " ".ANN_CHAMPS_NOM." LIKE \"".$_REQUEST['lettre']."%\"" ; |
$requete .= " ORDER BY ".ANN_CHAMPS_NOM ; |
|
111,6 → 111,7 |
<col /> |
<col /> |
<col /> |
<col /> |
</colgroup> |
<thead>\n |
<th> </th> |
119,6 → 120,7 |
<th>".ANN_DATE_INS."</th> |
<th>".ANN_CP."</th> |
<th>".ANN_VILLE."</th> |
<th>".ANN_PAYS."</th> |
</thead>"; |
|
$resultat= $GLOBALS['ann_db']->query($requete); |
141,7 → 143,8 |
<td>".str_replace(' - ', '-', ucwords(strtolower(str_replace('-', ' - ', $ligne[ANN_CHAMPS_PRENOM]))))." </td>\n |
<td>".date("d m Y", strtotime($ligne[ANN_CHAMPS_DATE_INS]))." </td>\n |
<td>".$ligne[ANN_CHAMPS_CODE_POSTAL]." </td>\n |
<td>".strtoupper($ligne[ANN_CHAMPS_VILLE])." </td>\n" ; |
<td>".strtoupper($ligne[ANN_CHAMPS_VILLE])." </td>\n |
<td>".str_replace(' - ', '-', ucwords(strtolower(str_replace('-', ' - ', ($ligne[ANN_GC_NOM])))))." </td>\n" ; |
$res .= "</tr>\n"; |
} |
$res .= "</table></div>\n"; |