<?php $server_ip = "localhost"; $mysql_user = ""; $mysql_pass = ""; $database = ""; $connect = mysql_connect("$server_ip", "$mysql_user", "$mysql_pass") or die(mysql_error()); $db_select = mysql_select_db("$database", $connect) or die(mysql_error()); $query = mysql_query("SELECT online FROM characters WHERE online=1") or die(mysql_error()) ; $online_chars = mysql_num_rows($query); echo 'Players Online:'.$online_chars; mysql_close($connect);?>