Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 359016" data-attributes="member: 36373">I tried to use a join statement, but I had a rough time because trying to get the specific user and then all that, so I was just going to use 2 queries in a while loop.[PHP]$q = mysql_query(&quot;SELECT * FROM users WHERE groupid = '&quot; . $job['id'] . &quot;' ORDER BY jobrank DESC&quot;) or die();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($user = mysql_fetch_assoc($q))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;table width='100%'&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;tr&gt;&lt;td width='0%'&gt;&quot;;&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 &quot;&lt;img src='&quot; . FigGen() . $user['figure'] . &quot;'&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $query2 = mysql_query(&quot;SELECT groupid,jobrank FROM users WHERE username = '&quot;.$user['username'].&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $query3 = mysql_query(&quot;SELECT name FROM jobranks WHERE jobrank = '&quot;.$query2['groupid'].&quot;' AND rankid = '&quot;.$query2['jobrank'].&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&nbsp; &nbsp; &nbsp; &nbsp; &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; &lt;td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;b&gt;Name:&lt;/b&gt; &quot; . $user['username'] . &quot; &lt;br/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;b&gt;Rank:&lt;/b&gt; &quot; . $query3['name'] . &quot; &lt;br/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;b&gt;Last visit:&lt;/b&gt; &quot; . date(&quot;F j, Y, g:i a&quot;,$user['timestamp_lastvisit']) . &quot;&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; &lt;/tr&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;/table&gt;&lt;hr&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/PHP]This is what the page looks like:<img src="http://i.imgur.com/5bvmd5c.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /> So I can't seem to get it to display the rank. Users Table -&gt; Groupid, jobrankJobranks Table -&gt; Jobid, rankid</blockquote>

[QUOTE="JayC, post: 359016, member: 36373"] I tried to use a join statement, but I had a rough time because trying to get the specific user and then all that, so I was just going to use 2 queries in a while loop. [PHP] $q = mysql_query("SELECT * FROM users WHERE groupid = '" . $job['id'] . "' ORDER BY jobrank DESC") or die(); while($user = mysql_fetch_assoc($q)) { echo "<table width='100%'>"; echo "<tr><td width='0%'>"; echo "<img src='" . FigGen() . $user['figure'] . "'>"; $query2 = mysql_query("SELECT groupid,jobrank FROM users WHERE username = '".$user['username']."'"); $query3 = mysql_query("SELECT name FROM jobranks WHERE jobrank = '".$query2['groupid']."' AND rankid = '".$query2['jobrank']."'"); echo " </td> <td> Name: " . $user['username'] . " Rank: " . $query3['name'] . " Last visit: " . date("F j, Y, g:i a",$user['timestamp_lastvisit']) . " </td> </tr>"; echo "</table><hr>"; } [/PHP] This is what the page looks like: [IMG]http://i.imgur.com/5bvmd5c.png[/IMG] So I can't seem to get it to display the rank. Users Table -> Groupid, jobrank Jobranks Table -> Jobid, rankid [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members