Code: |
<? $username="username"; $password="password"; $database="phpBB"; $host="mysql.mysite.com"; mysql_connect($host,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $sql = "SELECT count(user_id) as usercount FROM " . USERS_TABLE . ""; $result=mysql_query($sql); mysql_close(); echo $result; ?> |
Code: |
<?php [...] $result=mysql_query($sql); [...] echo $result; ?> |
Code: |
<?
$username="username"; $password="password"; $database="phpBB"; $host="mysql1.mysite.com"; mysql_connect($host,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $sql = "SELECT count(user_id) as usercount FROM phpbb_users"; if( !($result = mysql_query($sql)) ) echo '<b>Query: </b>' . $sql . '<br /><b>Status: </b><font color="red">Error running query (' . mysql_error() . ')</font><br /><br />'; while( $row = mysql_fetch_array($result) ) echo $row['usercount'] - 1; // So as to not count the anonymous user mysql_close(); ?> |
Code: |
<?
$username="username"; $password="password"; $database="phpBB"; $host="mysql1.mysite.com"; mysql_connect($host,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $sql = "SELECT user_id, username as usercount FROM phpbb_users WHERE user_id <> Anonymous ORDER BY user_id DESC LIMIT 1"; if( !($result = mysql_query($sql)) ) echo '<b>Query: </b>' . $sql . '<br /><b>Status: </b><font color="red">Error running query (' . mysql_error() . ')</font><br /><br />'; while( $row = mysql_fetch_array($result) ) echo $row['usercount']; // So as to not count the anonymous user mysql_close(); ?> |
Code: |
<?php
$username = "myusername"; $password = "mypassword"; $database = "mydatabase"; $host = "localhost"; mysql_connect($host, $username, $password); @mysql_select_db($database) or die("Problem selecting database."); $sql_newestuser = "SELECT * FROM phpbb_users WHERE user_id > -1 ORDER BY user_id DESC LIMIT 1"; $do_newestuser = mysql_query($sql_newestuser); $sql_usercount = "SELECT * FROM phpbb_users WHERE user_id > -1"; $do_usercount = mysql_query($sql_usercount); while ($result = mysql_fetch_array($do_newestuser)) echo "Newest User: ".$result['username']; echo "Total users: ".mysql_num_rows($do_usercount); ?> |
output generated using printer-friendly topic mod, All times are GMT + 2 Hours