if (($_POST['rechercher']=="OK") and ($_POST['recherche']!=""))
{
$query="SELECT titre, texte, photo, DATE_FORMAT(date_ins, '%d-%m-%Y'), heure_ins, compteur FROM 1two_news_news WHERE titre LIKE '%$recherche%' or texte LIKE '%$recherche%' ORDER BY date_ins DESC , heure_ins DESC";
$res_recherche = @mysql_query($query,$db);
if (@mysql_num_rows($res_recherche)!=0)
{
$nbrecherche=mysql_num_rows($res_recherche);
for ($i=0; $i<$nbrecherche; $i=$i+1)
{
$list_recherche=@mysql_fetch_row($res_recherche);
echo "";
echo "";
echo "";
echo "";
echo "";
echo "| $list_recherche[0] | ";
echo "Posté le $list_recherche[3] à $list_recherche[4] | ";
echo " ";
echo " ";
echo "";
echo "";
echo ""; if ($list_recherche[2]!="") {echo " ";} echo $list_recherche[1] . " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
}
}
}
?>
if (($_GET['action']!="poster") and ($_POST['rechercher']!="OK"))
{
$query="SELECT ordre_news, nbr_news FROM 1two_news_preferences";
$res_ordre_news = @mysql_query($query,$db);
$list_ordre_news=mysql_fetch_row($res_ordre_news);
if ($list_ordre_news[0]=="du plus ancien au plus récent")
{
$query="SELECT titre, texte, photo, DATE_FORMAT(date_ins, '%d-%m-%Y'), heure_ins, compteur FROM 1two_news_news ORDER BY date_ins ASC , heure_ins ASC";
$res_news = @mysql_query($query,$db);
}
else
{
$query="SELECT titre, texte, photo, DATE_FORMAT(date_ins, '%d-%m-%Y'), heure_ins, compteur FROM 1two_news_news ORDER BY date_ins DESC , heure_ins DESC";
$res_news = @mysql_query($query,$db);
}
if (@mysql_num_rows($res_news)!=0)
{
$nb=mysql_num_rows($res_news);
$nbpage=ceil($nb/$list_ordre_news[1]);
if ($_GET['page']=="") {$page=1;}
for ($i=0; $i<$nb; $i=$i+1)
{
$list_news=@mysql_fetch_row($res_news);
if ( ($i>=$list_ordre_news[1]*$page-$list_ordre_news[1]) and ($i<$list_ordre_news[1]*$page) )
{
echo "";
echo "";
echo "";
echo "";
echo "";
echo "| $list_news[0] | ";
echo "Posté le $list_news[3] à $list_news[4] | ";
echo " ";
echo " ";
echo "";
echo "";
echo ""; if ($list_news[2]!="") {echo " ";} echo $list_news[1] . " | ";
echo " ";
echo " ";
echo " | ";
echo "
";
}
else {}
}
}
echo "Page ";
for ($j=1; $j<=$nbpage; $j++) { echo " "; }
echo " ";
}
?>
|
|
|