scripts.php
<?php
include("config.php");
$con = @mysql_connect($my_host, $my_user, $my_pass);
$db = @mysql_select_db($my_data, $con);
if(!$con && !$db) {
die("Unable to connect to database");
}
elseif(!$con && $db) {
die("Unable to connect to database");
}
elseif($con && !$db) {
die("Unable to connect to database");
}
else {
function onlinePlayers() {
mysql_query("CREATE TABLE IF NOT EXISTS characters (id MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(60), online MEDIUMINT NOT NULL)");
$query = mysql_query("SELECT * FROM characters WHERE online = '1'");
$online = @mysql_num_rows($query);
echo "Online Players:" . $online;
echo "<br>";
while($r=mysql_fetch_array($query)){
echo $r['name'] . "<br>";
}
}
}
?>

Config.php:
<?php
$my_host = "localhost";
$my_user = "nadskap2";
$my_pass = "Xh353D442";
$my_data = "test";
?>

index.php:
<?php
include("scripts.php");
echo onlinePlayers();
?>