Editat: As vrea sa creez o functie asemanatoare (Sort by), care , in loc de Viewers si Skill sa aiba alte 'categorii', insa nu stiu cum sa fac query-ul la baza de date... Ma puteti ajuta cu functia ?
Sort by
Moderators: Moderatori ajutatori, Moderatori
- fan_haulin
- Fost moderator
- Posts: 2592
- Joined: 08 Jun 2010, 20:35
- Detinator Steam: Da
- Reputatie: Fost Moderator
- Has thanked: 271 times
- Been thanked: 106 times
- Contact:
- GPaul
- Membru, skill +4
- Posts: 1931
- Joined: 21 Mar 2009, 12:14
- Detinator Steam: Da
- CS Status: Inactiv. Studiu intens.
- Detinator server CS: - House M.D -
- SteamID: - House M.D -
- Reputatie: Nume anterior: djxpaulz
Fost super moderator - Location: Cluj-Napoca
- Has thanked: 8 times
- Been thanked: 174 times
- Contact:
Reformuleaza sa intelegem ceva, da si un exemplu concret sa vedem si noi ce vrei sa faci.
Personal, nu am inteles absolut nimic.
Personal, nu am inteles absolut nimic.
- fan_haulin
- Fost moderator
- Posts: 2592
- Joined: 08 Jun 2010, 20:35
- Detinator Steam: Da
- Reputatie: Fost Moderator
- Has thanked: 271 times
- Been thanked: 106 times
- Contact:
Am reformulat.Paul wrote:Reformuleaza sa intelegem ceva, da si un exemplu concret sa vedem si noi ce vrei sa faci.
Personal, nu am inteles absolut nimic.
-
- Fost administrator
- Posts: 13712
- Joined: 09 Oct 2010, 12:39
- Detinator Steam: Da
- CS Status: In grajd!
- SteamID: kalulord
- Reputatie: Fost Administrator
Fost membru Club eXtreamCS (6 luni)
Nume anterior: Terra - Location: Romania, Ploiesti
- Has thanked: 328 times
- Been thanked: 646 times
- Contact:
Code: Select all
<a href="page.php?sort=viewers">Viewers</a>
<a href="page.php?sort=skill">Skill</a>
<a href="page.php?sort=default_results">Default</a>
<?php
$sort_rules = isset($_GET['sort']) ? ($_GET['sort']) : "default_results";
switch($sort_rules){
case 'viewers':
print 'Viewers case';
/*
$table = $db->rawQuery("SELECT `field`, `field2`, `field3`, `field4` FROM `tableName` ORDER BY `viewers` DESC");
foreach($table as $key){
var_dump($key);
}
*/
break;
case 'skill':
print 'Skill case';
/*
$table = $db->rawQuery("SELECT `field`, `field2`, `field3`, `field4` FROM `tableName` ORDER BY `skill` DESC");
foreach($table as $key){
var_dump($key);
}
*/
break;
case 'default_results':
print 'Default case';
/*
$table = $db->rawQuery("SELECT `field`, `field2`, `field3`, `field4` FROM `tableName` ORDER BY `id`");
foreach($table as $key){
var_dump($key);
}
*/
break;
}
?>