salut
j'ai un très gros problème dans mon forum ben c'est tres dure a expliquer mais j'essaye.
Ben voila j'ai fait une page qui affiche les message ou le membre a participer le problème c'est dans les boucle je pense que c'est leur emplacement qui fait le problème, voila un screen de mon probleme:
http://img189.imageshack.us/img189/9296/bouclepartiuf4.gif
cliquez sur l'image pour le regarder
et voila le code:
<?php
include("header.php");
include("mysqlconect.php");
if(isset($_COOKIE['pseudo']) AND isset($_COOKIE['pass']) AND isset($_GET['id']) AND !empty($_GET['id']))
{
$pseudo = htmlentities(addslashes($_GET['id']));
$retoury = mysql_query("SELECT * FROM users WHERE id='" . $pseudo . "'");
$donney = mysql_fetch_array($retoury);
$pseudo = $donney['pseudo'];
?>
<title>Tout les messages ou <?php echo $pseudo; ?> a participer</title>
Sujet |
Auteur |
Nbr. de rep. |
<?php
$retour9 = mysql_query(\"select COUNT(*) FROM forums where type='sujets' AND pseudo='\" . $pseudo . \"'\");
$donne9 = mysql_result($retour9,0);
if(empty($donne9))
{
?>
----
<center>
<?php echo $pseudo; ?> n'a participer dans aucun message
</center>,
<?php
}
else
{
$retour1 = mysql_query(\"SELECT * FROM forums WHERE type='parti' AND pseudo='\" . $pseudo . \"'\");
while($donne1 = mysql_fetch_array($retour1))
{
$idf = $donne1['id_f'];
$retour2 = mysql_query(\"SELECT * FROM forums WHERE type='surforum' AND id_f='\" . $idf . \"'\");
$donne2 = mysql_fetch_array($retour2);
}
$surforum = $donne2['id_f'];
$retour3 = mysql_query(\"select COUNT(*) FROM forums where type='sujets' AND id_f='\" . $surforum . \"' AND pseudo='\" . $pseudo . \"'\");
$donne3 = mysql_result($retour3,0);
if(!empty($donne3))
{
?>
----
<center><?php echo $donne2['titre'] ; ?></center>,
<?php
$retour4 = mysql_query(\"SELECT * FROM forums WHERE type='forum' AND id_f='\" . $surforum . \"'\");
while($donne4 = mysql_fetch_array($retour4))
{
$forum = $donne4['id'];
$retour5 = mysql_query(\"select COUNT(*) FROM forums where type='sujets'AND id_f='\" . $surforum . \"' AND pseudo='\" . $pseudo . \"' AND id='\" . $forum . \"'\");
$donne5 = mysql_result($retour5,0);
if(!empty($donne5))
{
?>
----
<center><?php echo $donne4['titre'] ; ?></center>,
<?php
$retour6 = mysql_query(\"SELECT * FROM forums WHERE type='parti' AND id='\" . $forum . \"' AND id_f='\" . $surforum . \"' AND pseudo='\" . $pseudo . \"'\");
while($donne6 = mysql_fetch_array($retour6))
{
$sujet = $donne6['id2'];
$forum = $donne6['id'];
$surforum = $donne6['id_f'];
$retour8 = mysql_query(\"SELECT * FROM forums WHERE type='sujets' AND id='\" . $forum . \"' AND id_f='\" . $surforum . \"' AND id2='\" . $sujet . \"' AND pseudo='\" . $pseudo . \"'\");
$donne8 = mysql_fetch_array($retour8);
$pseudod = $donne8['pseudo'];
$retour9 = mysql_query(\"SELECT * FROM users WHERE pseudo='\" . $pseudod . \"'\");
$donne9 = mysql_fetch_array($retour9);
$retour10 = mysql_query(\"SELECT COUNT(*) AS nbre FROM forums WHERE type='sujets' AND id='\" . $forum . \"' AND id_f='\" . $surforum . \"' AND id2='\" . $sujet . \"' AND pseudo='\" . $pseudo . \"'\");
$donne10 = mysql_fetch_array($retour10);
$sujet = $donne6['id2'];
$pseucoo = htmlentities(addslashes($_COOKIE['pseudo']));
$lec = mysql_query(\"select COUNT(*) FROM forums where type='lect' AND id='\" . $forum . \"' AND id_f='\" . $idf . \"' AND id2='\" . $sujet . \"' AND pseudo='\" . $pseucoo . \"'\");
$lect = mysql_result($lec,0);
if(empty($lect))
{
$ouinon = \"non\";
}else{
$ouinon = \"oui\";
}
$lec2 = mysql_query(\"select COUNT(*) FROM forums where type='sujets' AND id='\" . $forum . \"' AND id_f='\" . $idf . \"' AND id2='\" . $sujet . \"' AND pseudo='\" . $pseucoo . \"'\");
$lect2 = mysql_result($lec2,0);
if(empty($lect2))
{
$ouinon2 = \"non\";
}else{
$ouinon2 = \"oui\";
}
?>
----
-<?php echo $ouinon2; ?>.gif">,
&forum=<?php echo $donne8['id'];?>&sujet=<?php echo $donne8['id2'];?>#titre"><?php echo $donne8['titre'];?>,
<center>"><?php echo $donne8['pseudo'];?></center>
,
<?php echo $donne10['nbre']; ?>
,
<?php
}
}
}
}
}
echo"
";
}
else
{
echo"Une erreur c'est produite.
";
}
?>
Merci d'avance
Afficher la suite