//fill in your mysql information here
$hostname = "1";
$username = "1";
$password = "1";
$database = "1";
mysql_connect($hostname,$username,$password);
mysql_select_db($database);
$query = "select * from `demo` GROUP BY name ".( isset($_GET[\'ordby\']) ? " ORDER BY " . $_GET[\'ordby\'] : "" ).""; 
$result = mysql_query($query);
//this if makes sure there is information in the table. if there isn\'t, there will be no output.
if (mysql_num_rows($result) > 0)
{
       //this creates a variable named $query_data and fills it with the information from the first row. using a while statement, this will repeat for each row the table contains.
while ($query_data = mysql_fetch_array($result))
{
               //we create new variables for each different column in the row.
 $id = $query_data[\'id\'];
 $account = $query_data[\'account\'];
 $name = $query_data[\'name\'];
 $guild = $query_data[\'guild\'];
 $kills = $query_data[\'kills\'];
 $fame = $query_data[\'fame\'];
 $karma = $query_data[\'karma\'];
echo "
";
   echo "";
    echo   " $name  |  $guild  |  $kills  | $fame | "; $karma  | 
echo "
";
}
}
?>
Вот скрипт но он неработает 
вот страница 
http://www.uo.ilva.lv/viewpage.php?page_id=12