Halo
Ik heb juni instal gedaan dat gaat perfect .
Dit is de code die ik in jumi heb geplaatst .
Code:
<table width="100%"><tr><td style="vertical-align:top;width:50%">
<span style="font-weight: bold; font-size: 12pt; text-decoration: underline; ">Ronde 1</span>
<br />
<?php $query = "SELECT CONCAT(a.voornaam,'' '',a.achternaam) as naam, a.*, b.score
FROM players as a
JOIN games_players as b
ON a.id = b.player_id WHERE game_id = 1
GROUP BY naam ORDER BY score DESC LIMIT 35";
$res = mysql_query($query) or die(mysql_error()); $cnt=1; while ($row = mysql_fetch_array($res)) {?>
<p><em><strong><?=$cnt?>.</strong></em> <strong><font color="9B2121">
<?=$row["score"]?> punten</font></strong> <font color="#939598"<?php if ($cnt<4) echo "#939598";
elseif ($cnt<7) echo "#FFFFFF";
elseif ($cnt < 10) echo "#939598";
else echo "#939598";
?>">
<?=$row["naam"]?></font></p>
<?php $cnt++;}?>
</td><td style="vertical-align:top;width:50%">
<span style="font-weight: bold; font-size: 12pt; text-decoration: underline; ">Ronde 2</span>
<div><br />
</div><?php
$query = "SELECT CONCAT(a.voornaam,'' '',a.achternaam) as naam, a.*, b.score
FROM players as a
JOIN games_players as b
ON a.id = b.player_id
WHERE game_id = 2
GROUP BY naam ORDER BY score DESC LIMIT 35";
$res = mysql_query($query) or die(mysql_error());
$cnt=1; while ($row = mysql_fetch_array($res)){?>
<p><em><strong><?=$cnt?>.</strong></em> <strong><font color="9B2121">
<?=$row["score"]?> punten</font></strong> <font color="#939598"
<?php
if ($cnt<4) echo "#939598";
elseif ($cnt<7) echo "#FFFFFF";
elseif ($cnt < 10) echo "#939598";
else echo "#939598";?>">
<?=$row["naam"]?></font></p>
<?php $cnt++;
}?>
</td></tr>
En krijg mijn footer ook terug in de punten maar dat is niet het plan :-s
klik hier
Heeft onderwerp gestart
