Reply to thread

Message

<blockquote data-quote="Whip" data-source="post: 300313" data-attributes="member: 39479">If You Still Need Help Here PHP Coded Just Add To Page. [PHP]&lt;div class=&quot;habblet-container &quot;&gt;&lt;div class=&quot;cbb clearfix red&quot;&gt;&lt;h2 class=&quot;title&quot;&gt;{hotelName} Statistics&lt;/h2&gt;&lt;div id=&quot;notfound-content&quot; class=&quot;box-content&quot;&gt; &lt;center&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Users online: &lt;?php $sql = &quot;SELECT COUNT(*) FROM users WHERE online = '1'&quot;;$query = mysql_query($sql) or die(mysql_error());$hoeveel = mysql_result($query,0,0);echo $hoeveel;&nbsp; ?&gt; &lt;br&gt;Registered Users:&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalleden FROM users&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalleden'];?&gt;&lt;br /&gt;Rooms:&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalkamers FROM rooms&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalkamers'];?&gt;&lt;br /&gt;Badges:&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalbadges FROM user_badges&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalbadges'];?&gt;&lt;br /&gt;Favorite rooms:&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalfavouritekamers FROM user_favorites&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalfavouritekamers'];?&gt;&lt;br /&gt;Furniture:&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalmeubels FROM furniture&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalmeubels'];?&gt;&lt;br /&gt;Furniture in the catalog:&lt;?php$query = mysql_query(&quot;SELECT COUNT(*) AS aantalmeubels FROM catalog_items&quot;) or die(mysql_error());$data = mysql_fetch_assoc($query);echo $data['aantalmeubels'];?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/center&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; [/PHP]</blockquote>

[QUOTE="Whip, post: 300313, member: 39479"] If You Still Need Help Here PHP Coded Just Add To Page. [PHP]<div class="habblet-container "> <div class="cbb clearfix red"> <h2 class="title">{hotelName} Statistics</h2> <div id="notfound-content" class="box-content"> <center> Users online: <?php $sql = "SELECT COUNT(*) FROM users WHERE online = '1'"; $query = mysql_query($sql) or die(mysql_error()); $hoeveel = mysql_result($query,0,0); echo $hoeveel; ?> Registered Users: <?php $query = mysql_query("SELECT COUNT(*) AS aantalleden FROM users") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalleden']; ?> Rooms: <?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM rooms") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalkamers']; ?> Badges: <?php $query = mysql_query("SELECT COUNT(*) AS aantalbadges FROM user_badges") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalbadges']; ?> Favorite rooms: <?php $query = mysql_query("SELECT COUNT(*) AS aantalfavouritekamers FROM user_favorites") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalfavouritekamers']; ?> Furniture: <?php $query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM furniture") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalmeubels']; ?> Furniture in the catalog: <?php $query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM catalog_items") or die(mysql_error()); $data = mysql_fetch_assoc($query); echo $data['aantalmeubels']; ?> </center></a></div></div> </div> [/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members