I use that in my new Website wich is coming soon
Before open MySQL Connect with:
Code:
mysql_connect("HOST/IP HERE", "USERNAME" ,"PASSWORD")
Then use the following Code to select the Database:
Code:
mysql_select_db("DATABASENAME");
$res = mysql_query("SELECT count(*) FROM accounts;");
$val = mysql_fetch_array($res);
echo "<td>Accounts: ".$val[0]."<br>";
$res2 = mysql_query("SELECT count(*) FROM characters;");
$val2 = mysql_fetch_array($res2);
echo "Characters: ".$val2[0]."<br>";
$res2 = mysql_query("SELECT count(*) FROM guilds;");
$val2 = mysql_fetch_array($res2);
echo "Guilds: ".$val2[0]."<br>";
$res2 = mysql_query("SELECT count(*) FROM accounts WHERE Status like '8'");
$val2 = mysql_fetch_array($res2);
echo "GM's: ".$val2[0]."</td>";
If it helps use Thanks