sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not obtain posts information', '', __LINE__, __FILE__, $sql); } $posts = $db->sql_fetchrow($result); $total_posts = $posts['total_posts']; $sql = "SELECT COUNT(*) AS total_topics FROM " . TOPICS_TABLE; if(!$result = $db->sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not obtain topics information', '', __LINE__, __FILE__, $sql); } $topics = $db->sql_fetchrow($result); $total_topics = $topics['total_topics']; $sql = "SELECT COUNT(*) AS total_users FROM " . USERS_TABLE; if(!$result = $db->sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not obtain users information', '', __LINE__, __FILE__, $sql); } $users = $db->sql_fetchrow($result); $total_users = $users['total_users']; $sql = "SELECT username FROM " . USERS_TABLE . " ORDER BY user_id DESC LIMIT 1"; if(!$result = $db->sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not obtain username information', '', __LINE__, __FILE__, $sql); } $usernames = $db->sql_fetchrow($result); $newest_user = $usernames['username']; ?> We currently have users
We currently have posts
We currently have topics
Our newest user is