




|
|
require("config.inc.php3");
/* connexion à la base de données ------------------------------------------- */
$db = mysql_connect("$host", "$login", "$password");
mysql_select_db("$base",$db);
$request = MYSQL_QUERY("SELECT id FROM light_forum_tbl");
$max_mess = MYSQL_NUMROWS($request);
$req = MYSQL_QUERY("SELECT * FROM light_forum_tbl WHERE reponse_a_id='0' ORDER BY date_verif DESC LIMIT 0, $limit");
$res = MYSQL_NUMROWS($req);
// affichage tableau haut -------------
print("<$align> \n");
print("\n");
print("\n");
print("\n");
print("\n");
print("\n");
print("\n");
print(" \n");
// ------------------------------------
print("| \n");
print(" Messages (réponses) | \n");
print("\n");
print(" Auteur : | \n");
print("Posté le : | \n");
// ------------------------------------
$bgcolor = "#C0C0C0";
$i=0;
WHILE($i!=$res)
{
$id = mysql_result($req,$i,"id");
$nom = mysql_result($req,$i,"nom");
$email = mysql_result($req,$i,"email");
$date = mysql_result($req,$i,"date");
$heure = mysql_result($req,$i,"heure");
$titre = mysql_result($req,$i,"titre");
$titre = substr("$titre", 0, $carac);
$titre = stripslashes(stripslashes($titre));
$rep = mysql_query("SELECT reponse_a_id FROM light_forum_tbl WHERE reponse_a_id='$id'");
$nb_rep = mysql_numrows($rep);
if($nb_rep>'1'){ $reptexte = " et les réponses apportées"; }
elseif($nb_rep=='1'){ $reptexte = " et la réponse apportée"; }
elseif($nb_rep=='0'){ $reptexte = ""; }
if($bgcolor=='#C0C0C0'){ $bgcolor="#E5E1D1"; }else{ $bgcolor="#C0C0C0"; }
// ------------------------------------
print("| \n");
print("$titre ($nb_rep) | \n");
print("\n");
print(" $nom | \n");
print("$date à $heure | \n");
$i++;
}
// affichage tableau bas --------------
print(" | | \n");
print(" | ");
// ------------------------------------
print("\n");
// ------------------------------------
MYSQL_CLOSE();
/* FIN -------------------------------- */
?>
|