$clan = $_GET['clan'];
$order = $_GET['order'];
if (isset($clan)) {
$clan = str_replace(array('"','<','>'),'',$clan);
$sql = "SELECT * FROM `clan` WHERE `clannimi`=". $db->quoteSmart($clan);
$result = $db->getRow($sql);
echo(' Klaanitiedot: '. stripslashes($result->clannimi) .'');
?>
Klaanin kuvaus:
echo str_replace("\n"," ",stripslashes($result->clankuvaus)); ?>
|
Klaanin tapaamiset:
echo str_replace("\n"," ",stripslashes($result->clantapaamiset)); ?>
|
}
?>
Klaanit
if (!isset($order))
$order = 'clannimi';
echo('');
$sql = "SELECT * FROM `clan` ORDER by ".$order;
$result = $db->query($sql);
while ($row =& $result->fetchRow()) {
echo (' ');
}
?>
|