News ";
if(isset($_SESSION["admin"])&&$_SESSION["admin"])
echo '';
echo "";
$link = mysql_connect(__MYSQL_HOSTNAME__, __MYSQL_USERNAME__, __MYSQL_PASSWORD__)
or die("Impossible de se connecter : " . mysql_error());
if(!mysql_select_db('crep', $link)){
echo 'Selection de la base de donnees impossible';
exit;
}
mysql_query("SET NAMES 'utf8'");
$requete = "select news.pk as pk, DATE_FORMAT(created,'%e-%m-%Y') AS created, title, content, users.realname as userName from news, users where news.fk_author=users.pk;";
$resultat = mysql_query($requete);
//Pour debugger
if (!$resultat) {
$message = 'Requete invalide : ' . mysql_error() . "\n";
$message .= 'Requete complete : ' . $query;
die($message);
}
while ($row = mysql_fetch_assoc($resultat)) {
echo '';
echo '
';
echo '
'.$row['title'];
if(isset($_SESSION["admin"])&&$_SESSION["admin"])
echo ' ';
echo '
';
echo '
';
echo '
';
echo '
'.$row['content'].'
';
echo '
';
echo '