Placering igen
Hej EksperterJeg har fået lavet denne kode af coderdk lige som jeg bad om, men jeg havde misforstået det jeg blev bet op, nemlig at placeringen skulle virke som i plads i excel, se her under
--------------------
Plads | Navn | Point
1 | Hans | 118
2 | John | 115
2 | Jens | 115
4 | Peter| 114
5 | Ib | 113
--------------------
Som man kan se forsætte placeringen, men alle som har samme point får samme plads.
Her er koden som coderdk har lavet til mig
<?php
$i = 0;
$sql = "
SELECT
c.horse_type, c.disciplin_id, c.year, c.horse_id, SUM( c.point ) AS point
,u.user_id, u.name AS uname, h.name AS hname
FROM
rl_competition AS c
INNER JOIN
rl_horses AS h
ON
c.horse_id = h.horse_id
INNER JOIN
rl_users AS u
ON
h.user_id = u.user_id
WHERE
c.year = '$_GET[aar]'
AND c.disciplin_id = '$_GET[disciplin]'
AND c.horse_type = '$_GET[type]'
GROUP BY
c.horse_id
ORDER BY
SUM(point) DESC
,SUM(IF(c.competition_place='1',1,0)) DESC
";
$get_horses = mysql_query($sql) or die(mysql_error());
$old = 0;
while ($row = mysql_fetch_array($get_horses)) {
if ( $row['point'] != $old )
{
$i++;
$old = $row['point'];
}
?>
<tr>
<td class="td9">
<strong><?php echo $i;?></strong>
</td>
<td class="td8">
<a class="fkrlink" href="competitions.php?show_user=<?php echo $row['user_id']; ?>&aar=<?php echo $_GET['aar']; ?>"><?php echo $row['uname']; ?></a>
</td>
<td class="td8">
<?php echo $row['hname']; ?>
</td>
<td class="td9">
<?php echo $row['point']; ?>
</td>
</tr>
<?php
}
?>
</table>
Mvh ZiPs