$rank++ opslaan in database
Mijn vraag is, is er een manier waarop ik die rank ook in een database kan krijgen?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
2
3
4
5
6
7
8
9
10
11
12
13
<?
$result = mysql_query("SELECT * FROM table ORDER BY clic DESC");
$rank = 1;
echo "<table border=\"0\"><tr><td>Game Name</td><td>Category</td><td>Hits</td><td>Rank</td></tr>";
while($row = mysql_fetch_array($result)){
echo "<tr><td>" . $row['nom'] . "</td><td>" . $row['cat'] . "</td><td>" . $row['clic'] . "</td><td>" . $rank . "</td></tr>";
$rank++;
}
echo "</table>";
?>
$result = mysql_query("SELECT * FROM table ORDER BY clic DESC");
$rank = 1;
echo "<table border=\"0\"><tr><td>Game Name</td><td>Category</td><td>Hits</td><td>Rank</td></tr>";
while($row = mysql_fetch_array($result)){
echo "<tr><td>" . $row['nom'] . "</td><td>" . $row['cat'] . "</td><td>" . $row['clic'] . "</td><td>" . $rank . "</td></tr>";
$rank++;
}
echo "</table>";
?>
ik heb de goeie code gevonden trouwens:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?
$result = mysql_query("SELECT * FROM table ORDER BY clic DESC");
$rank = 1;
echo "<table border=\"0\"><tr><td>Game Name</td><td>Category</td><td>Hits</td><td>Rank</td></tr>";
while($row = mysql_fetch_array($result)){
echo "<tr><td>" . $row['nom'] . "</td><td>" . $row['cat'] . "</td><td>" . $row['clic'] . "</td><td>" . $rank . "</td></tr>";
mysql_query("update `table` SET `rank` = '". $rank ."' WHERE `id` = '". $row['id'] ."'") or die (Mysql_Error());
$rank++;
}
echo "</table>";
?>
$result = mysql_query("SELECT * FROM table ORDER BY clic DESC");
$rank = 1;
echo "<table border=\"0\"><tr><td>Game Name</td><td>Category</td><td>Hits</td><td>Rank</td></tr>";
while($row = mysql_fetch_array($result)){
echo "<tr><td>" . $row['nom'] . "</td><td>" . $row['cat'] . "</td><td>" . $row['clic'] . "</td><td>" . $rank . "</td></tr>";
mysql_query("update `table` SET `rank` = '". $rank ."' WHERE `id` = '". $row['id'] ."'") or die (Mysql_Error());
$rank++;
}
echo "</table>";
?>
En als klap op de vuurpijl ook nog backtics ` in je queries...