par
Arno76 » 22 déc. 2006, 15:16
Voila ma boucle je ne comprend pas comment mettre en palce votre systeme
<?php
$echo = mysql_query("SELECT *FROM `photo` where statut='". 1 ."' order by `vote` DESC ");
$donnee = mysql_query($echo);
$i = 0;
while ($donnee = mysql_fetch_array($echo))
{
$i ++;
$id = $donnee['id'];
$joueurs = $donnee['pseudo'];
$img = $donnee['img'];
$vote = $donnee['vote'];
$statut = $donnee['statut'];
?>
<TABLE width="508" height="200" border="0" align="center" cellpadding="0" cellspacing="0">
<TR>
<TD bgcolor="#FFCC33"><?php echo $i ; ?></TD>
<TD bgcolor="#FFCC33"><?php echo $joueurs ; ?></TD>
<TD> </TD>
<TD bgcolor="#FFCC33"><?php echo $i ; ?></TD>
<TD bgcolor="#FFCC33"><?php echo $joueurs ; ?></TD>
<TD> </TD>
<TD bgcolor="#FFCC33"><?php echo $i ; ?></TD>
<TD bgcolor="#FFCC33"><?php echo $joueurs ; ?></TD>
</TR>
<TR>
<TD colspan="2"><A href="popup.php?id=<?php echo $i ;?>" onClick="window.open(this.href, 'Support', 'height=500, width=750, top=307, left=307, toolbar=no, menubar=no, location=no, resizable=yes, scrollbars=yes, status=no'); return false;" ><IMG src="./photo/<?php echo $img ; ?>" width="100" height="100" border="0" /></A></TD>
<TD> </TD>
<TD colspan="2"><A href="popup.php?id=<?php echo $i ;?>" onClick="window.open(this.href, 'Support', 'height=500, width=750, top=307, left=307, toolbar=no, menubar=no, location=no, resizable=yes, scrollbars=yes, status=no'); return false;" ><IMG src="./photo/<?php echo $img ; ?>" width="100" height="100" border="0" /></A></TD>
<TD> </TD>
<TD colspan="2"><A href="popup.php?id=<?php echo $i ;?>" onClick="window.open(this.href, 'Support', 'height=500, width=750, top=307, left=307, toolbar=no, menubar=no, location=no, resizable=yes, scrollbars=yes, status=no'); return false;" ><IMG src="./photo/<?php echo $img ; ?>" width="100" height="100" border="0" /></A></TD>
</TR>
<TR>
<TD colspan="2" bgcolor="#FFCC33"><?php echo $vote ; ?></TD>
<TD> </TD>
<TD colspan="2" bgcolor="#FFCC33"><?php echo $vote ; ?></TD>
<TD> </TD>
<TD colspan="2" bgcolor="#FFCC33"><?php echo $vote ; ?></TD>
</TR>
</TABLE>
<BR>
<?php
}
?>
Voila ma boucle je ne comprend pas comment mettre en palce votre systeme :roll:
[php] <?php
$echo = mysql_query("SELECT *FROM `photo` where statut='". 1 ."' order by `vote` DESC ");
$donnee = mysql_query($echo);
$i = 0;
while ($donnee = mysql_fetch_array($echo))
{
$i ++;
$id = $donnee['id'];
$joueurs = $donnee['pseudo'];
$img = $donnee['img'];
$vote = $donnee['vote'];
$statut = $donnee['statut'];
?>
<TABLE width="508" height="200" border="0" align="center" cellpadding="0" cellspacing="0">
<TR>
<TD bgcolor="#FFCC33"><?php echo $i ; ?></TD>
<TD bgcolor="#FFCC33"><?php echo $joueurs ; ?></TD>
<TD> </TD>
<TD bgcolor="#FFCC33"><?php echo $i ; ?></TD>
<TD bgcolor="#FFCC33"><?php echo $joueurs ; ?></TD>
<TD> </TD>
<TD bgcolor="#FFCC33"><?php echo $i ; ?></TD>
<TD bgcolor="#FFCC33"><?php echo $joueurs ; ?></TD>
</TR>
<TR>
<TD colspan="2"><A href="popup.php?id=<?php echo $i ;?>" onClick="window.open(this.href, 'Support', 'height=500, width=750, top=307, left=307, toolbar=no, menubar=no, location=no, resizable=yes, scrollbars=yes, status=no'); return false;" ><IMG src="./photo/<?php echo $img ; ?>" width="100" height="100" border="0" /></A></TD>
<TD> </TD>
<TD colspan="2"><A href="popup.php?id=<?php echo $i ;?>" onClick="window.open(this.href, 'Support', 'height=500, width=750, top=307, left=307, toolbar=no, menubar=no, location=no, resizable=yes, scrollbars=yes, status=no'); return false;" ><IMG src="./photo/<?php echo $img ; ?>" width="100" height="100" border="0" /></A></TD>
<TD> </TD>
<TD colspan="2"><A href="popup.php?id=<?php echo $i ;?>" onClick="window.open(this.href, 'Support', 'height=500, width=750, top=307, left=307, toolbar=no, menubar=no, location=no, resizable=yes, scrollbars=yes, status=no'); return false;" ><IMG src="./photo/<?php echo $img ; ?>" width="100" height="100" border="0" /></A></TD>
</TR>
<TR>
<TD colspan="2" bgcolor="#FFCC33"><?php echo $vote ; ?></TD>
<TD> </TD>
<TD colspan="2" bgcolor="#FFCC33"><?php echo $vote ; ?></TD>
<TD> </TD>
<TD colspan="2" bgcolor="#FFCC33"><?php echo $vote ; ?></TD>
</TR>
</TABLE>
<BR>
<?php
}
?>
[/php]