Something

public text v1 · immutable
#131033
·published 2006-08-14 09:02 UTC
 <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
           <?php
			  
// Traitement des accents et des espaces
$accents = "ÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËèéêëÇçÌÍÎÏìíîïÙÚÛÜùúûüÿÑñ' ";
$sansaccents = "AAAAAAaaaaaaOOOOOOooooooEEEEeeeeCcIIIIiiiiUUUUuuuuyNn--";
			  
require ('../admin/config.php');
  
// On cr&eacute;&eacute; la requ&ecirc;te SQL 
$sql = "SELECT * FROM dossiers_Dossier ORDER BY id DESC";

// On envoie la requ&ecirc;te
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());

while($data = mysql_fetch_assoc($req)) 
    { 
echo '<td>&#8226; <a href="Dossier_'.strtr($data['titre'],$accents,$sansaccents).'_'.$data['id'].'.html">'.$data['titre'].'</a></td>';
}
?>        
<?php
// On cr&eacute;&eacute; la requ&ecirc;te SQL 
$sql = "SELECT * FROM dossiers_Interview ORDER BY id DESC";

// On envoie la requ&ecirc;te
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());

while($data = mysql_fetch_assoc($req)) 
    { 
echo '<td>&#8226; <a href="Interview_'.strtr($data['titre'],$accents,$sansaccents).'_'.$data['id'].'.html">'.$data['titre'].'</a></td><tr>';
}
 mysql_close();
 ?>