Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 330437" data-attributes="member: 36373">$getMembers=mysql_query(&quot;SELECT id,age,country,username,motto,look,position,online,age,country,last_online,owner_bio FROM users WHERE rank = '&quot;.$Ranks['id'].&quot;'&quot;); Do not fucking code like this. What are we, 2?$getMembers=mysql_query(&quot;SELECT * FROM users WHERE rank = '&quot;.$Ranks['id'].&quot;'&quot;);the star grabs every column value then just say$getMembers['column'];[DOUBLEPOST=1427727361,1427726974][/DOUBLEPOST]
<ol>
<li data-xf-list-type="ol"><ol>
<li data-xf-list-type="ol">$getRanks = mysql_query(&quot;SELECT * FROM ranks WHERE id = 7 ORDER BY id DESC&quot;);</li>
<li data-xf-list-type="ol"> 
</li>
<li data-xf-list-type="ol">while ($Ranks = mysql_fetch_assoc($getRanks))</li>
<li data-xf-list-type="ol">{&nbsp; &nbsp;&nbsp; </li>
<li data-xf-list-type="ol">&nbsp; &nbsp; &nbsp;&nbsp; echo ' &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; </li>
<li data-xf-list-type="ol">&lt;div class=&quot;cbb clearfix blue &quot;&gt;</li>
<li data-xf-list-type="ol">&lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;' . $Ranks['name'] . </li>
</ol></li>
</ol>Line 1) Put * instead of id,namethat might fix it. The reason is because the query already contains id,name and when you call to getRanks with the While loop it fucks up.</blockquote>

[QUOTE="JayC, post: 330437, member: 36373"] $getMembers=mysql_query("SELECT id,age,country,username,motto,look,position,online,age,country,last_online,owner_bio FROM users WHERE rank = '".$Ranks['id']."'"); Do not fucking code like this. What are we, 2? $getMembers=mysql_query("SELECT [B]* [/B]FROM users WHERE rank = '".$Ranks['id']."'"); the star grabs every column value then just say $getMembers['column']; [DOUBLEPOST=1427727361,1427726974][/DOUBLEPOST][LIST=1] [LIST=1] [*]$getRanks = mysql_query("SELECT * FROM ranks WHERE id = 7 ORDER BY id DESC"); [*] [*]while ($Ranks = mysql_fetch_assoc($getRanks)) [*]{ [*] echo ' <div class="habblet-container "> [*]<div class="cbb clearfix blue "> [*]<h2 class="title">' . $Ranks['name'] . [/LIST] [/LIST] Line 1) Put * instead of id,name that might fix it. The reason is because the query already contains id,name and when you call to getRanks with the While loop it fucks up. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members