Sorteren op veriabel
Is dit mogelijk?
Mvg, Nousie
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<?php
$sqlgeldl = "SELECT * FROM users";
$geldzak = mysql_query($sqlgeldl);
echo '<table>';
echo '<tr><td><b>Username</td><td>Netwaarde</b></td>';
echo '<tr><td></td><td></td>';
while ($rowgeldjeuh = mysql_fetch_assoc($geldzak)){
$username = $rowgeldjeuh['username'];
$soldaattjes = $rowgeldjeuh['soldaten'];
$verdedigers = $rowgeldjeuh['verdedigers'];
$land = $rowgeldjeuh['land'];
$goudf = $rowgeldjeuh['goudfabrieken'];
$nw1 = $verdedigers + $soldaattjes + $land + $goudf;
$nw = round($nw1 * 2);
echo '<tr><td>'.$username.'</td><td>'.$nw.'</td></tr>';
}
echo'</table>'
?>
$sqlgeldl = "SELECT * FROM users";
$geldzak = mysql_query($sqlgeldl);
echo '<table>';
echo '<tr><td><b>Username</td><td>Netwaarde</b></td>';
echo '<tr><td></td><td></td>';
while ($rowgeldjeuh = mysql_fetch_assoc($geldzak)){
$username = $rowgeldjeuh['username'];
$soldaattjes = $rowgeldjeuh['soldaten'];
$verdedigers = $rowgeldjeuh['verdedigers'];
$land = $rowgeldjeuh['land'];
$goudf = $rowgeldjeuh['goudfabrieken'];
$nw1 = $verdedigers + $soldaattjes + $land + $goudf;
$nw = round($nw1 * 2);
echo '<tr><td>'.$username.'</td><td>'.$nw.'</td></tr>';
}
echo'</table>'
?>
Code (php)
1
2
3
4
5
2
3
4
5
<?php
$sqlgeldl = "
SELECT username, ROUND((verdedigers + soldaten + land + goudfabrieken) * 2) AS nw
FROM users";
?>
$sqlgeldl = "
SELECT username, ROUND((verdedigers + soldaten + land + goudfabrieken) * 2) AS nw
FROM users";
?>
Jan Koehoorn schreef op 03.11.2006 10:05:
Code (php)
1
2
3
4
5
6
2
3
4
5
6
<?php
$sqlgeldl = "
SELECT username, ROUND((verdedigers + soldaten + land + goudfabrieken) * 2) AS nw
FROM users
ORDER BY nw";
?>
$sqlgeldl = "
SELECT username, ROUND((verdedigers + soldaten + land + goudfabrieken) * 2) AS nw
FROM users
ORDER BY nw";
?>
Gewijzigd op 01/01/1970 01:00:00 door Willem Jan Z