Reply to thread

Message

<blockquote data-quote="FirefighterKyle" data-source="post: 358496" data-attributes="member: 22469">Okay so I am trying to make a rank page for a game I am playing, I am having a hard time understanding why it shows the wrong ranks when I am calling something else.Here is my code.[PHP]&lt;?php&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $rankCount = mysql_num_rows(mysql_query(&quot;SELECT * FROM `ranks` WHERE `type` = '1' &amp;&amp; `branch` = 1&quot;));&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($rankCount &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for ($i=1; $i&lt;=$rankCount; $i++)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $rankInfo = mysql_fetch_array(mysql_query(&quot;SELECT * FROM `ranks` WHERE `ladder` = '&quot;.$i.&quot;'&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getMembers = mysql_query(&quot;SELECT * FROM `members` WHERE `position` = '&quot;.$rankInfo['id'].&quot;' ORDER BY `update_date` ASC&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;a href=&quot;#&quot;&gt;'.$rankInfo['title'].' ('.mysql_num_rows($getMembers).')&lt;/a&gt;&lt;br /&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (mysql_num_rows($getMembers) &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($memberInfo = mysql_fetch_array($getMembers))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;100%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;strong&gt;Name:&lt;/strong&gt; &lt;a href=&quot;/member/'.$memberInfo['id'].'&quot;&gt;'.$memberInfo['name'].'&lt;/a&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;strong&gt;Tag:&lt;/strong&gt; '.$memberInfo['tag'].'&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '.$memberInfo['train_promo'].' &lt;strong&gt;'.$memberInfo['promo_by'].'&lt;/strong&gt; on '.date(&quot;m/d/y&quot;, $memberInfo['update_date']).'&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;strong&gt;Graded by:&lt;/strong&gt; '.$memberInfo['graded_by'].'&lt;br /&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; '&lt;i&gt;There currently no on in this position.&lt;/i&gt;&lt;br /&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; '&lt;i&gt;This branch has no ranks yet please check back later.&lt;/i&gt;';&nbsp; &nbsp; ?&gt;[/PHP]<img src="http://i.imgur.com/R7CG60h.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /> It should show (Private, PFC, Senior Private, and Corporal) but it is showing the last 4 like so (Minister of HS, Director oO, General, and Lieuten Gen) Why won't it show the Private etc since I am saying to show &quot;`type` = 1&quot; ??</blockquote>

[QUOTE="FirefighterKyle, post: 358496, member: 22469"] Okay so I am trying to make a rank page for a game I am playing, I am having a hard time understanding why it shows the wrong ranks when I am calling something else. Here is my code. [PHP]<?php $rankCount = mysql_num_rows(mysql_query("SELECT * FROM `ranks` WHERE `type` = '1' && `branch` = 1")); if ($rankCount > 0) { for ($i=1; $i<=$rankCount; $i++) { $rankInfo = mysql_fetch_array(mysql_query("SELECT * FROM `ranks` WHERE `ladder` = '".$i."'")); $getMembers = mysql_query("SELECT * FROM `members` WHERE `position` = '".$rankInfo['id']."' ORDER BY `update_date` ASC"); echo '<a href="#">'.$rankInfo['title'].' ('.mysql_num_rows($getMembers).')</a> '; if (mysql_num_rows($getMembers) > 0) { while($memberInfo = mysql_fetch_array($getMembers)) { echo '<table width="100%"> <tr> <td> Name: <a href="/member/'.$memberInfo['id'].'">'.$memberInfo['name'].'</a> Tag: '.$memberInfo['tag'].' '.$memberInfo['train_promo'].' '.$memberInfo['promo_by'].' on '.date("m/d/y", $memberInfo['update_date']).' Graded by: '.$memberInfo['graded_by'].' </td></tr></table>'; } } else 'There currently no on in this position. '; } } else 'This branch has no ranks yet please check back later.'; ?>[/PHP] [IMG]http://i.imgur.com/R7CG60h.png[/IMG] It should show (Private, PFC, Senior Private, and Corporal) but it is showing the last 4 like so (Minister of HS, Director oO, General, and Lieuten Gen) Why won't it show the Private etc since I am saying to show "`type` = 1" ?? [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members