Untitled


<?php include("password_protect.php"); ?>
<html>
<head>
<title>Connecting MySQL Server</title>
</head>
<body>
<?php


//MYSQL STUFF
   $dbhost = 'localhost';
   $dbuser = 'tsarpf';
   $dbpass = 'dynamite';
   $database = 'tsarpf_simobotdb';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   if(! $conn )
   {
     die('Could not connect: ' . mysql_error());
   }
   echo 'Connected successfully';
   @mysql_select_db($database) or die( "Unable to select database");

   $queryNicklist="SELECT DISTINCT nick FROM SimoMsg";
    $resultNicklist=mysql_query($queryNicklist);
    $numberOfNicks = mysql_numrows($resultNicklist);


       echo "<h2> <center> Lines / usard</center> </h2><br><br>";
    $i = 0;
    while($i < $numberOfNicks)
    {
        $nick = mysql_result($resultNicklist,$i,"nick");
        $queryNumberOfLines="SELECT COUNT(*) FROM SimoMsg WHERE nick = '" + $nick + "';";
        $resultNumberOfLines=mysql_query($queryNumberOfLines);
        $nickNumberOfLines= mysql_result($resultNumberOfLines,0);

        echo "<pre>$nick\t$nickNumberOfLines</pre>";
        $i++;

    }


mysql_close($conn);
?>
</body>
</html>