Reply to thread

Message

<blockquote data-quote="Stephan" data-source="post: 115893" data-attributes="member: 18646">Hello. Can someone help me with my staff page? When I enter this PHP code on my website it shows the rank ID 5 and higher. But I only want the rank ID 5 and not higher and not lower. How to do that? Here's the PHP code:[PHP]&lt;?php&nbsp; &nbsp; $GetRanks = mysql_query(&quot;SELECT id, name FROM ranks WHERE id &gt; '5' ORDER BY id DESC&quot;);&nbsp; &nbsp; while($Ranks = mysql_fetch_assoc($GetRanks))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $GetUsers = mysql_query(&quot;SELECT username,motto,last_online,online,look FROM users WHERE rank = {$Ranks['id']}&quot;);&nbsp; &nbsp; &nbsp; &nbsp; while($Users = mysql_fetch_assoc($GetUsers))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($Users['online'] == 1){ $OnlineStatus = &quot;&lt;font color=\&quot;green\&quot;&gt;Online&lt;/font&gt;&quot;; } else { $OnlineStatus = &quot;&lt;font color=\&quot;red\&quot;&gt;Offline&lt;/font&gt;&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;img style=\&quot;position:absolute;\&quot; src=\&quot;http://www.habbo.nl/habbo-imaging/avatarimage?figure={$Users['look']}&amp;head_direction=3&amp;direction=3&amp;gesture=sml&amp;action=std&amp;size=b\&quot;&gt;&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .&quot;&lt;p style=\&quot;margin-left:70px;margin-top:40px;\&quot;&gt;&lt;strong&gt;{$Users['username']} ({$OnlineStatus})&lt;/strong&gt;&lt;br&gt;Missie: &lt;i&gt;{$Users['motto']}&lt;/i&gt;&lt;br&gt;&lt;small&gt;Laatste bezoek: &quot;. date(&quot;D, d F Y H:i (P)&quot;, $Users['last_online']) .&quot;&lt;/small&gt;&lt;/p&gt;&lt;br&gt;&lt;br&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;/p&gt;&lt;br&gt;&quot;;&nbsp; &nbsp; }?&gt;[/PHP]Thanks for helping.</blockquote>

[QUOTE="Stephan, post: 115893, member: 18646"] Hello. Can someone help me with my staff page? When I enter this PHP code on my website it shows the rank ID 5 and higher. But I only want the rank ID 5 and not higher and not lower. How to do that? Here's the PHP code: [PHP]<?php $GetRanks = mysql_query("SELECT id, name FROM ranks WHERE id > '5' ORDER BY id DESC"); while($Ranks = mysql_fetch_assoc($GetRanks)) { $GetUsers = mysql_query("SELECT username,motto,last_online,online,look FROM users WHERE rank = {$Ranks['id']}"); while($Users = mysql_fetch_assoc($GetUsers)) { if($Users['online'] == 1){ $OnlineStatus = "Online"; } else { $OnlineStatus = "Offline"; } echo "<img style=\"position:absolute;\" src=\"http://www.habbo.nl/habbo-imaging/avatarimage?figure={$Users['look']}&head_direction=3&direction=3&gesture=sml&action=std&size=b\">" ."{$Users['username']} ({$OnlineStatus}) Missie: {$Users['motto']} Laatste bezoek: ". date("D, d F Y H:i (P)", $Users['last_online']) ." "; } echo " "; } ?>[/PHP] Thanks for helping. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members