[ News ]
if (@$_GET['mode'] == 'voir')
{
$nb=$_GET['nb'];
$sql = "SELECT *,DATE_FORMAT(".$table.".date,'%d-%m-%y ŕ %T') as date FROM ".$table.",tr_user_news WHERE ".$table.".user_id=tr_user_news.user_id AND news_id=$nb AND validite='1' ";
$p = mysql_query($sql);
while($row=mysql_fetch_assoc($p)){
?>
echo $row['titre']; ?>
echo post($row['message']); ?>
Posté par echo $row['pseudo']; ?> le echo $row['date']; ?>
}
$sql2 = "SELECT *,DATE_FORMAT(".$table2.".date,'%d-%m-%y ŕ %T') as date FROM ".$table2." WHERE news_id=$nb ";
$p2 = mysql_query($sql2);
while ($row2 = mysql_fetch_assoc($p2)){
?>
echo $row2['titre']; ?>
echo post($row2['message']); ?>
Posté par echo $row2['pseudo']; ?> le echo $row2['date']; ?>
}
}
else
{
$sql = "SELECT *,DATE_FORMAT(".$table.".date,'%d-%m-%y ŕ %T') as date FROM ".$table.",tr_user_news WHERE ".$table.".user_id=tr_user_news.user_id AND validite='1' ORDER BY news_id DESC LIMIT 0,$nb";
$p = mysql_query($sql);
if (mysql_num_rows($p) == 0)
{
echo "
Pas de nouvelles
";
}
else
{
while($row=mysql_fetch_assoc($p)){
$sql2 = "SELECT * FROM ".$table3." WHERE categorie_id=".$row['categorie_id']."";
$p2 = mysql_query($sql2);
$row2=mysql_fetch_assoc($p2);
$cat=$row2['icone'];
?>