Tables sorteren kwa value
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
<?
echo "There users are online:<br />";
echo "<table width=\"30%\"><tr><td>User</td><td>Level</td><td>XP</td><td>Gold</td><td>Kill/Death Ratio</td></tr>";
mysql_select_db('logon', $con);
$sql = mysql_query("SELECT * FROM characters WHERE online='1'");
while($result = mysql_fetch_array($sql)){
echo "<tr><td>";
echo $result['name'];
echo "</td><td> ";
echo $result['level'];
echo "</td><td> ";
echo $result['xp'];
echo "</td><td>";
echo $result['gold'];
echo "<img src=\"Coins-icon.jpg\"><td></td>";
echo $result['killsLifeTime'];
echo "</td></tr></table>";
?>
echo "There users are online:<br />";
echo "<table width=\"30%\"><tr><td>User</td><td>Level</td><td>XP</td><td>Gold</td><td>Kill/Death Ratio</td></tr>";
mysql_select_db('logon', $con);
$sql = mysql_query("SELECT * FROM characters WHERE online='1'");
while($result = mysql_fetch_array($sql)){
echo "<tr><td>";
echo $result['name'];
echo "</td><td> ";
echo $result['level'];
echo "</td><td> ";
echo $result['xp'];
echo "</td><td>";
echo $result['gold'];
echo "<img src=\"Coins-icon.jpg\"><td></td>";
echo $result['killsLifeTime'];
echo "</td></tr></table>";
?>
van elke gebruiker die online is komt er een aantal info naar beneden (Naam, Ledel, ...) ik wil de users kunnen sorteren per value.
Gewijzigd op 01/01/1970 01:00:00 door Sandy Cohen
(Of wilde je iets vragen?)
van elke gebruiker die online is komt er een aantal info naar beneden (Naam, Ledel, ...) ik wil de users kunnen sorteren per value.
Maar zoiets:
In de table:
<a href="?order=name">Name</a>
In de PHP-zooi:
Code (php)
1
2
3
4
5
2
3
4
5
<?php
$sOrder = isset($_GET['order']) AND in_array($_GET['order'], array('name', 'anderveld', 'anderveld')) ? $_GET['order'] : 'standaardveld';
mysql_query("SELECT velden FROM tabel ORDER BY " . $sOrder);
?>
$sOrder = isset($_GET['order']) AND in_array($_GET['order'], array('name', 'anderveld', 'anderveld')) ? $_GET['order'] : 'standaardveld';
mysql_query("SELECT velden FROM tabel ORDER BY " . $sOrder);
?>