Inversé l'ordre chronologique des commentaires

Question

ancien

5 Feb 2013 à 15:55

Bonjour a tous,
Sur mon site d'actualités les membres peuvent ajoutés des commentaires.
Les commentaire s'affiche dans l'ordre chronologique du plus ancien au plus récent.
Je souhaiterai l'inverse du plus récent au plus ancien.
Merci d'avance pour votre aide
Modifié par ancien (15 Feb 2013 - 16:06)

SylvainG

5 Feb 2013 à 20:23

Il faut modifier ta requête SQL. Elle doit te retourner une liste de résultats classés par date décroissante.

SELECT * FROM commentaires WHERE id = MON_ID ORDER BY date DESC

Modifié par SylvainG (07 Feb 2013 - 11:01)

ancien

5 Feb 2013 à 20:40

Que dois-je faire exactement ?

LeMuTaLisKFoU

6 Feb 2013 à 09:59

Salut,

D'après un de tes précédents posts tu utilises un Wordpress, tu devrais le préciser si tu veux des réponses plus précises.

Regarde cet article, il résout ton problème.

ancien

6 Feb 2013 à 11:39

Salut
Non pour cette modification c'est un site unique le wordpress c'est pour un collègue. Ton article c'est pour wordpress ou sa concerne tout types de sites ?
Modifié par ancien (06 Feb 2013 - 11:42)

LeMuTaLisKFoU

6 Feb 2013 à 14:40

Le lien que je t'ai donné c'est pour Wordpress.

Dans ce cas là, la réponse de SylvainG répond très bien à ton problème ^^
Modifié par LeMuTaLisKFoU (06 Feb 2013 - 14:40)

ancien

6 Feb 2013 à 15:12

Ok mais je n'ai pas comprit ce que je dois faire ?

LeMuTaLisKFoU

6 Feb 2013 à 16:22

Quelque part dans ton code php tu as une requête qui affiche les commentaires et tu dois la modifier pour changer l'ordre d'affichage.

Il faut ajouter ORDER BY <nom de ta colonne qui contient les dates dans la base de données> DESC comme dans l'exemple de SylvainG.

ancien

6 Feb 2013 à 18:38

Je ne trouve pas le code

LeMuTaLisKFoU

7 Feb 2013 à 08:24

Peux-tu nous montrer une partie du code de la page des commentaires ? Smiley smile

SylvainG

7 Feb 2013 à 11:07

LeMuTaLisKFoU a écrit :
Peux-tu nous montrer une partie du code de la page des commentaires ?

Ce serait effectivement plus simple...

ancien

7 Feb 2013 à 14:25

Merci pour vos réponses:
Voici les pages qui peuvent être concernées:
Page index.php

<?php include "header.php"; 

?>
<div style="float:left;width:700px;margin-top:10px;margin-left:10px;">	
<div class="slideshow"> 
<?php 
$sssss = mysql_query("SELECT * FROM une order by rand() limit 0,5") or die('Erreur SQL !<br>'.$sssss.'<br>'.mysql_error());
while($s = mysql_fetch_array($sssss))
	{
	$requete = mysql_query("SELECT * FROM articles where id='".$s['idarticle']."'") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
	while($r = mysql_fetch_array($requete))
		{
echo '<a href="article-'.$r['url'].'.html"><div style="background:url(une/'.$r['photo'].')no-repeat;background-position:'.$r['align'].';width:700px;height:300px;cursor:pointer;">
		<div style="float:left;background:url(img/fondunenews.png)no-repeat;width:700px;height:100px;margin-top:200px;">
			<div id="alaune" style="float:left;width:680px;margin-left:10px;margin-right:10px;color:#fff;">
			<span>'.stripslashes($r['titre']).'</span><br />
			<p align="justify">';
	$nbmot=strlen(strip_tags($r['msg']));
	if($nbmot>254) { echo substr(strip_tags($r['msg']), 0, 254).'...'; } else { 
	echo strip_tags($r['msg']);
	}
			echo '</p>
			</div>
		</div>
	</div></a>';
	
}
}
?>
<?
?>
<?

?>
	
</div>

<?php 
	$requete = mysql_query("SELECT * FROM articles order by id desc limit 0,3") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
	while($r = mysql_fetch_array($requete))
		{
			$requetecommentaire = mysql_query("SELECT * FROM comm where idarticle='".$r['id']."'") or die('Erreur SQL !<br>'.$requetecommentaire.'<br>'.mysql_error());
			$lenombredecomm=mysql_num_rows($requetecommentaire);

		$lelien="article-".$r['url'].".html";
	echo '<span id="grosarticle" style="margin-top:10px;width:700px;"><h1><span style="font-size:13px;margin-right:10px;background:#7D0000;color:#fff;">';
	if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
	echo '</span>'.stripslashes($r['titre']).'</h1></span>
	<a href="'.$lelien.'"><div style="background:url(une/'.$r['photo'].')no-repeat;background-position:'.$r['align'].';width:700px;height:250px;cursor:pointer;"></div></a>
	
	<div style="float:left;margin-right:10px;margin-top:5px;margin-bottom:5px;font-size:13px;width:60px;text-align:center;margin-right:10px;background:#7D0000;color:#fff;">'.$r['vu'].' vues</div>
	<div style="float:left;margin-top:5px;margin-bottom:5px;font-size:13px;width:120px;text-align:center;margin-right:10px;background:#7D0000;color:#fff;"><a class="blanc" href="'.$lelien.'#comm">'.$lenombredecomm.' commentaires</a></div>
	<div id="clear"></div>
	<span style="font-size:16px">';
$nbmot=strlen(strip_tags($r['msg']));
if($nbmot>310) { echo substr(strip_tags($r['msg']), 0, 310).'...'; } else { 
echo strip_tags($r['msg']);
}
	echo ' <a class="rouge" href="'.$lelien.'">[Lire la suite]</a></span><br /><img border="0" src="img/separation.png" width="700" height="30"><br />';	
		}
	
	echo '<div id="clear"> </div>';
	
	//ptiteune
function switchfloat()
 { 
   static $col;
   $couleur1 = "left";
   $couleur2 = "right";

    if ($col == $couleur1)
     {
       $col = $couleur2;
     }
    else
     {
       $col = $couleur1;
     }
    return $col; 
 }

 
 /* $results = array();
$index = 0;
$requete = mysql_query("SELECT * FROM articles order by id desc limit 3,10") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
while($r = mysql_fetch_array($requete))
{
       if(isset($results[$index]) && count($results[$index]) == 1){
               $results[$index++][] = $r;
               
       }else{
               $results[$index] = array($r);
       }
}

// apres il faut faire

foreach($results as $result){
       // attention $result est un array qui contient deux valeurs
       echo '<div>';
		   foreach($result as $sqlRow){
		   echo $sqlRow['titre'];
		   //echo print_r($result);
		   }
       echo implode('<div id="clear"> </div>', $result);
       echo '</div>';
}
  */
 

 
include "pagination.php";
 $query = mysql_query("SELECT COUNT(*) FROM articles  ORDER BY id desc") or die(mysql_error());
  $nb_entrees = mysql_result($query,0,0);
 
  $entrees_par_page = 50; 
  $total_pages = ceil($nb_entrees/$entrees_par_page); 

  if(!isset($_GET['page'])){
  $page_courante = 1; 

  } else {
  $page = $_GET['page'];
  if ($page<1) $page_courante=1; 
  elseif ($page>$total_pages) $page_courante=$total_pages; 
  else $page_courante=$page; 
  }
//$start = ($page_courante * $entrees_par_page - $entrees_par_page);
$start = 3;
$query = "SELECT * FROM articles ORDER BY id desc LIMIT $start, $entrees_par_page";
$resultat = mysql_query($query);

  while($r = mysql_fetch_array($resultat)) {
  			$requetecommentaire = mysql_query("SELECT * FROM comm where idarticle='".$r['id']."'") or die('Erreur SQL !<br>'.$requetecommentaire.'<br>'.mysql_error());
			$lenombredecomm=mysql_num_rows($requetecommentaire);
		$lelien="article-".$r['url'].".html";
		echo '<div style="float:'.switchfloat().';width:340px;min-height:360px;margin-bottom:20px;">';
	echo '<span id="ptitarticle" style="margin-top:10px;width:340px;"><h1><span style="font-size:13px;margin-right:10px;background:#7D0000;color:#fff;">';
	if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
	echo '</span>'.stripslashes($r['titre']).'</h1></span>
	<a href="'.$lelien.'"><div style="background:url(une/ptiteune_'.$r['photo'].')no-repeat;background-position:'.$r['align'].';width:340px;height:100px;cursor:pointer;"></div></a>
		
	<div style="float:left;margin-right:10px;margin-top:5px;margin-bottom:5px;font-size:13px;width:60px;text-align:center;margin-right:10px;background:#7D0000;color:#fff;">'.$r['vu'].' vues</div>
	<div style="float:left;margin-top:5px;margin-bottom:5px;font-size:13px;width:120px;text-align:center;margin-right:10px;background:#7D0000;color:#fff;"><a class="blanc" href="'.$lelien.'">'.$lenombredecomm.' commentaires</a></div>
	<div id="clear"></div>
	
	
	<span style="font-size:16px">';
$nbmot=strlen(strip_tags($r['msg']));
if($nbmot>310) { echo substr(strip_tags($r['msg']), 0, 310).'...'; } else { 
echo strip_tags($r['msg']);
}
	echo ' <a class="rouge" href="'.$lelien.'">[Lire la suite]</a></span>
	</div>';	

		}	 
echo '<div style="float:left;margin-left:0px;margin-top:20px;margin-bottom:20px;width:700px;">';
  //echo pagination($total_pages,$page_courante);
echo '</div>'; 	
		
		
?>


</div>
<div style="float:left;width:280px;margin-top:10px;margin-left:0px;"><div style="float:left;width:274px;margin-left:10px;">
<?php include "pub250.php"; ?>
<iframe src="//www.facebook.com/plugins/likebox.php?href=https%3A%2F%2Fwww.facebook.com%2Fpages%2FVirtuActu-Une-actualit%25C3%25A9-r%25C3%25A9elle-sur-un-site-virtuel%2F246700182094989&amp;width=274&amp;height=258&amp;colorscheme=light&amp;show_faces=true&amp;border_color=%23ffffff&amp;stream=false&amp;header=false&amp;appId=101126620019580" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:274px; height:258px;" allowTransparency="true"></iframe>
</div><div id="clear">
<div style="float:left;width:274px;margin-left:10px;"><img border="0" src="img/img10derniers.png" width="274" height="56"></div>
<div style="float:left;width:274px;margin-left:10px;">
<?php
echo '<table border="0" width="274" cellspacing="0" cellpadding="0">';
$requete = mysql_query("SELECT * FROM articles order by id desc limit 0,10") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
while($r = mysql_fetch_array($requete))
	{
$lelien="article-".$r['url'].".html";
echo '<tr>
		<td width="80"><span style="font-size:13px;">'; 
if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
echo '</span></td>
		<td><a class="rougelink" href="'.$lelien.'"><b>'.stripslashes($r['titre']).'</b></a></td>
	</tr>
		<tr>
		<td width="80">&nbsp;</td>
		<td>&nbsp;</td>
	</tr>';
	}

echo '</table><br />';
?>
<a class="twitter-timeline"  href="https://twitter.com/Virtuactu" data-widget-id="296302951469817857">Tweets de @Virtuactu</a>
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src="//platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>

<br /></div><div style="float:left;width:274px;margin-left:10px;"><img border="0" src="img/plusvues.png" width="274" height="56"></div>
<br /></div><div style="float:left;width:274px;margin-left:10px;">
<?php

echo '<table border="0" width="274" cellspacing="0" cellpadding="0">';
$requete = mysql_query("SELECT * FROM articles order by vu desc limit 0,10") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
while($r = mysql_fetch_array($requete))
	{
$lelien="article-".$r['url'].".html";
echo '<tr>
		<td width="80"><span style="font-size:13px;">'; 
if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
echo '</span></td>
		<td><a class="rougelink" href="'.$lelien.'"><b>'.stripslashes($r['titre']).'</b></a></td>
	</tr>
		<tr>
		<td width="80">&nbsp;</td>
		<td>&nbsp;</td>
	</tr>';
	}

echo '</table><br />';
?>
</div>

</div>
<div id="clear"> </div>


<?php include "foot.php"; ?>

Page fiche.php

<?php include "header.php"; ?>
<div style="float:left;width:700px;margin-top:10px;margin-left:10px;">	

<?php
$urldusite=protection($_GET['url']);
$requete = mysql_query("SELECT * FROM articles WHERE url='".$urldusite."'") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
	while($r = mysql_fetch_array($requete))
		{
	$nbvue=mysql_query("UPDATE articles set vu=vu+1 WHERE id='".$r['id']."'") or die('Erreur SQL !'.$nbvue.'<br /><br />'.mysql_error()); 
			$requetecommentaire = mysql_query("SELECT * FROM comm where idarticle='".$r['id']."'") or die('Erreur SQL !<br>'.$requetecommentaire.'<br>'.mysql_error());
			$lenombredecomm=mysql_num_rows($requetecommentaire);
	echo '<span id="grosarticle" style="margin-top:10px;width:700px;"><h1><span style="font-size:13px;margin-right:10px;background:#7D0000;color:#fff;">';
	if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
	echo '</span>'.stripslashes($r['titre']).'</h1></span>
	<div style="background:url(une/'.$r['photo'].')no-repeat;background-position:'.$r['align'].';width:700px;height:250px;">
	&nbsp;
	</div>
		
	<div style="float:left;margin-right:10px;margin-top:5px;margin-bottom:5px;font-size:13px;width:60px;text-align:center;margin-right:10px;background:#7D0000;color:#fff;">'.$r['vu'].' vues</div>
	<div style="float:left;margin-top:5px;margin-bottom:5px;font-size:13px;width:120px;text-align:center;margin-right:10px;background:#7D0000;color:#fff;"><a class="blanc" href="#comm">'.$lenombredecomm.' commentaires</a></div>
	<div id="clear"></div>
	
	<span style="font-size:16px;">'.$r['msg'].'</span><!-- AddThis Button BEGIN -->
<div class="addthis_toolbox addthis_default_style" style="float:left;margin-left:150px;">
<a class="addthis_button_facebook_like" fb:like:layout="button_count"></a>
<a class="addthis_button_tweet"></a>
<a class="addthis_button_google_plusone" g:plusone:size="medium"></a>
<a class="addthis_counter addthis_pill_style"></a>
</div>
<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#pubid=xa-4f8fd5c9645b7b80"></script>
<!-- AddThis Button END --><br /><a name="comm"><img border="0" src="img/separation.png" width="700" height="30"></a>';
	if (isset($_SESSION['clemembre'])) {
	echo '<form method="POST" action="#">
	<p align="center"><textarea rows="5" name="msg" cols="65"></textarea></p>
	<p align="center"><input type="hidden" value="'.$r['id'].'" name="idarticle"><input type="hidden" value="ok" name="form"><input type="submit" value="Publier mon commentaire" name="B1"></p>
</form>';	
	} else {
	echo '
	<p align="center"><textarea rows="5" name="msg" cols="65"></textarea></p>
	<p align="center"><input type="hidden" value="ok" name="form"><input type="submit" value="Publier mon commentaire" name="B1" onclick="javascript:alert(\'Vous devez être inscrit et connecté pour commenter cet article.\');"></p>';
	}
		$requete = mysql_query("SELECT * FROM comm WHERE idarticle='".$r['id']."'") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
		$nbcomm=mysql_num_rows($requete);
		if($nbcomm==0) { echo '<p align="center">&nbsp;</p><p align="center">&nbsp;</p><p align="center">Aucun commentaire</p><p align="center">&nbsp;</p><p align="center">&nbsp;</p>'; 
		} else {
		while($r = mysql_fetch_array($requete))
			{
			$requetsssse = mysql_query("SELECT * FROM membres WHERE cle='".$r['cle']."'") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
			while($s = mysql_fetch_array($requetsssse))
				{
			echo '<p>Ajouté par <strong>'.$s['pseudo'].'</strong> le '.date("d/m/Y", strtotime($r['date'])).' à '.date("H:i", strtotime($r['date'])).'</p><p>'.$r['msg'].'</p><img border="0" src="img/separation.png" width="700" height="30">';	
				}
			}
		  }
		}
 ?>




</div>
<div style="float:left;width:280px;margin-top:10px;margin-left:0px;"><div style="float:left;width:274px;margin-left:10px;">
<?php include "pub250.php"; ?>
<iframe src="//www.facebook.com/plugins/likebox.php?href=https%3A%2F%2Fwww.facebook.com%2Fpages%2FVirtuActu-Une-actualit%25C3%25A9-r%25C3%25A9elle-sur-un-site-virtuel%2F246700182094989&amp;width=274&amp;height=258&amp;colorscheme=light&amp;show_faces=true&amp;border_color=%23ffffff&amp;stream=false&amp;header=false&amp;appId=101126620019580" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:274px; height:258px;" allowTransparency="true"></iframe>
</div><div id="clear">
<div style="float:left;width:274px;margin-left:10px;"><img border="0" src="img/img10derniers.png" width="274" height="56"></div>
<div style="float:left;width:274px;margin-left:10px;">
<?php
echo '<table border="0" width="274" cellspacing="0" cellpadding="0">';
$requete = mysql_query("SELECT * FROM articles order by id desc limit 0,10") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
while($r = mysql_fetch_array($requete))
	{
$lelien="article-".$r['url'].".html";
echo '<tr>
		<td width="80"><span style="font-size:13px;">'; 
if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
echo '</span></td>
		<td><a class="rougelink" href="'.$lelien.'"><b>'.stripslashes($r['titre']).'</b></a></td>
	</tr>
		<tr>
		<td width="80">&nbsp;</td>
		<td>&nbsp;</td>
	</tr>';
	}

echo '</table><br />';
?>
<a class="twitter-timeline"  href="https://twitter.com/Virtuactu" data-widget-id="296302951469817857">Tweets de @Virtuactu</a>
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src="//platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>

<br /></div><div style="float:left;width:274px;margin-left:10px;"><img border="0" src="img/plusvues.png" width="274" height="56"></div>
<br /></div><div style="float:left;width:274px;margin-left:10px;">
<?php

echo '<table border="0" width="274" cellspacing="0" cellpadding="0">';
$requete = mysql_query("SELECT * FROM articles order by vu desc limit 0,10") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
while($r = mysql_fetch_array($requete))
	{
$lelien="article-".$r['url'].".html";
echo '<tr>
		<td width="80"><span style="font-size:13px;">'; 
if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
echo '</span></td>
		<td><a class="rougelink" href="'.$lelien.'"><b>'.stripslashes($r['titre']).'</b></a></td>
	</tr>
		<tr>
		<td width="80">&nbsp;</td>
		<td>&nbsp;</td>
	</tr>';
	}

echo '</table><br />';
?>
</div>

</div>
<div id="clear"> </div>


<?php include "foot.php"; ?>

Page ficheadmin.php

<?php include "header.php"; ?>
<div style="float:left;width:700px;margin-top:10px;margin-left:10px;">	

<?php
$urldusite=protection($_GET['id']);
$requete = mysql_query("SELECT * FROM articles WHERE id='".$urldusite."'") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
	while($r = mysql_fetch_array($requete))
		{
	//$nbvue=mysql_query("UPDATE articles set vu=vu+1 WHERE id='".$r['id']."'") or die('Erreur SQL !'.$nbvue.'<br /><br />'.mysql_error()); 

	echo '<span id="grosarticle" style="margin-top:10px;width:700px;"><h1><span style="font-size:13px;margin-right:10px;background:#7D0000;color:#fff;">';
	if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
	echo '</span>'.stripslashes($r['titre']).'</h1></span>
	<div style="background:url(une/'.$r['photo'].')no-repeat;background-position:'.$r['align'].';width:700px;height:250px;">
	&nbsp;
	</div><span style="font-size:16px;">'.$r['msg'].'</span><!-- AddThis Button BEGIN -->
<div class="addthis_toolbox addthis_default_style" style="float:left;margin-left:150px;">
<a class="addthis_button_facebook_like" fb:like:layout="button_count"></a>
<a class="addthis_button_tweet"></a>
<a class="addthis_button_google_plusone" g:plusone:size="medium"></a>
<a class="addthis_counter addthis_pill_style"></a>
</div>
<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#pubid=xa-4f8fd5c9645b7b80"></script>
<!-- AddThis Button END --><br /><img border="0" src="img/separation.png" width="700" height="30">';
	if (isset($_SESSION['clemembre'])) {
	echo '<form method="POST" action="#">
	<p align="center"><textarea rows="5" name="msg" cols="65"></textarea></p>
	<p align="center"><input type="hidden" value="'.$r['id'].'" name="idarticle"><input type="hidden" value="ok" name="form"><input type="submit" value="Publier mon commentaire" name="B1"></p>
</form>';	
	} else {
	echo '
	<p align="center"><textarea rows="5" name="msg" cols="65"></textarea></p>
	<p align="center"><input type="hidden" value="ok" name="form"><input type="submit" value="Publier mon commentaire" name="B1" onclick="javascript:alert(\'Vous devez être inscrit et connecté pour commenter cet article.\');"></p>';
	}
		$requete = mysql_query("SELECT * FROM comm WHERE idarticle='".$r['id']."'") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
		$nbcomm=mysql_num_rows($requete);
		if($nbcomm==0) { echo '<p align="center">&nbsp;</p><p align="center">&nbsp;</p><p align="center">Aucun commentaire</p><p align="center">&nbsp;</p><p align="center">&nbsp;</p>'; 
		} else {
		while($r = mysql_fetch_array($requete))
			{
			$requetsssse = mysql_query("SELECT * FROM membres WHERE cle='".$r['cle']."'") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
			while($s = mysql_fetch_array($requetsssse))
				{
			echo '<p>Ajouté par <strong>'.$s['pseudo'].'</strong> le '.date("d/m/Y", strtotime($r['date'])).' à '.date("H:i", strtotime($r['date'])).'</p><p>'.$r['msg'].'</p><img border="0" src="img/separation.png" width="700" height="30">';	
				}
			}
		  }
		}
 ?>




</div>
<div style="float:left;width:280px;margin-top:10px;margin-left:0px;"><div style="float:left;width:274px;margin-left:10px;">
<?php include "pub250.php"; ?>
<iframe src="//www.facebook.com/plugins/likebox.php?href=https%3A%2F%2Fwww.facebook.com%2Fpages%2FVirtuActu-Une-actualit%25C3%25A9-r%25C3%25A9elle-sur-un-site-virtuel%2F246700182094989&amp;width=274&amp;height=258&amp;colorscheme=light&amp;show_faces=true&amp;border_color=%23ffffff&amp;stream=false&amp;header=false&amp;appId=101126620019580" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:274px; height:258px;" allowTransparency="true"></iframe>
</div><div id="clear">
<div style="float:left;width:274px;margin-left:10px;"><img border="0" src="img/img10derniers.png" width="274" height="56"></div>
<div style="float:left;width:274px;margin-left:10px;">
<?php
echo '<table border="0" width="274" cellspacing="0" cellpadding="0">';
$requete = mysql_query("SELECT * FROM articles order by id desc limit 0,10") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
while($r = mysql_fetch_array($requete))
	{
$lelien="article-".$r['url'].".html";
echo '<tr>
		<td width="80"><span style="font-size:13px;">'; 
if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
echo '</span></td>
		<td><a class="rougelink" href="'.$lelien.'"><b>'.stripslashes($r['titre']).'</b></a></td>
	</tr>
		<tr>
		<td width="80">&nbsp;</td>
		<td>&nbsp;</td>
	</tr>';
	}

echo '</table><br />';
?>
<a class="twitter-timeline"  href="https://twitter.com/Virtuactu" data-widget-id="296302951469817857">Tweets de @Virtuactu</a>
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src="//platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>

<br /></div><div style="float:left;width:274px;margin-left:10px;"><img border="0" src="img/plusvues.png" width="274" height="56"></div>
<br /></div><div style="float:left;width:274px;margin-left:10px;">
<?php

echo '<table border="0" width="274" cellspacing="0" cellpadding="0">';
$requete = mysql_query("SELECT * FROM articles order by vu desc limit 0,10") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
while($r = mysql_fetch_array($requete))
	{
$lelien="article-".$r['url'].".html";
echo '<tr>
		<td width="80"><span style="font-size:13px;">'; 
if(date("d/m/Y", strtotime($r['date']))!==date("d/m/Y", strtotime($date))) { echo date("d/m/Y", strtotime($r['date'])); } else { echo date("H:i", strtotime($r['date'])); }
echo '</span></td>
		<td><a class="rougelink" href="'.$lelien.'"><b>'.stripslashes($r['titre']).'</b></a></td>
	</tr>
		<tr>
		<td width="80">&nbsp;</td>
		<td>&nbsp;</td>
	</tr>';
	}

echo '</table><br />';
?>
</div>

</div>
<div id="clear"> </div>


<?php include "foot.php"; ?>

SylvainG

7 Feb 2013 à 16:14

Sur la page fiche.php, essaye de modifier la requête SQL en t'inspirant du modèle que je t'ai donné plus haut.

$requete = mysql_query("SELECT * FROM comm WHERE idarticle='".$r['id']."'") or die('Erreur SQL !<br>'.$requete.'<br>'.mysql_error());
		$nbcomm=mysql_num_rows($requete);

ancien

7 Feb 2013 à 16:24

Il y a plusieurs fois ce code dans ma page dois-je le changer pour chaque code ?

SylvainG

7 Feb 2013 à 18:03

Testes, tu verras bien ! Je te promets, ça ne pique pas ! Smiley lol

Sujet clos

Sémantique web et HTML

Inversé l'ordre chronologique des commentaires