edit now new error i have add mysql pass now i take Warning: mysql_connect() [function.mysql-connect]: Host 'web.fr1.hostchefs.net' is not allowed to connect to this MySQL server in /home/lnukecom/public_html/index.php on line 206
Host 'web.fr1.hostchefs.net' is not allowed to connect to this MySQL server
<?php $server_ip = "ip from dedicate"; $mysql_user = "root"; $mysql_pass = "pass from mysql"; $database = "l2jdb"; $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); ?>