---

kaip ideti toki koda?
<?php
//first you need to define db info
define('mySQL_hostname', 'localhost' ); //database IP
define('mySQL_database', 'l2jdb' ); //database name
define('mySQL_username', 'l2jdb' ); //database user
define('mySQL_password', 'xxxx' ); //database password

//connects to mysql
$db_link = mysql_connect( mySQL_hostname, mySQL_username, mySQL_password )
or die( 'Error connecting to mysql<br><br>' . mysql_error() );

//connects to Database
$db_select = mysql_select_db( mySQL_database, $db_link )
or die( 'Error connecting to Database<br><br>' . mysql_error() );

//selects desired table
$chars=mysql_query('SELECT * FROM characters' );
if (!$chars) {
die('Invalid query: ' . mysql_error());
}

//tells how much rows are there (will come helpfull with while loops)
$rows = mysql_num_rows($chars);

$i=0;
$x=0;

//while $i is smaller than number of rows repeat the code
while ($i < $rows) {
$online=mysql_result($chars,$i,"online" );
//looks into characters table, under column online(if player is online its "0" else "1" ), at row $i
if ($online == 1) {
$x++;
} // if column online at row $i is "1", increase $x
$i++; //increase $i
}
echo "<font color=\"0080FF\">Razedx100:<em>" . $x . "</em></font>"; //prints out the $x number of players online

mysql_close($db_link);

echo "<br>";
ir i kur det