<?php
session_start();
mysql_connect('localhost', 'root', '');
mysql_select_db('c');
$a = mysql_query("SELECT * FROM users ORDER by id") or die(mysql_error());
$b = mysql_num_rows($a);
if ($b > 0)
{
echo "<table>";
echo "<tr><td>#</td><td>Username</td><td>Pol</td><td>Skype</td><td>Predstavqne</td><td>Klan</td></tr>";
while ($r = mysql_fetch_array($a))
{
$id = $r['id'];
$user = htmlspecialchars($r['user']);
$pol = htmlspecialchars($r['pol']);
if ($pol == "m") { $sex = "Мъж"; } else { $sex = "Жена"; }
$skype = htmlspecialchars($r['skype']);
$desc = htmlspecialchars($r['desc']);
$clan = htmlspecialchars($r['clan']);
echo "<tr><td>$id</td><td>$user</td><td>$sex</td><td>$skype</td><td>$desc</td><td>$clan</td></tr>";
}
}
else
{
echo "Nqma namereni potrebiteli.";
}
?>
