Reply to thread

Message

<blockquote data-quote="Kristopher" data-source="post: 388955" data-attributes="member: 1958">So if you check the code below in the spoiler[spoiler]&lt;?php &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; $query = &quot;SELECT username, respects_received, look FROM users AND users_settings WHERE rank &lt; 7 ORDER BY respects_received DESC LIMIT 10&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; &nbsp; &nbsp; &nbsp; &nbsp; $result = mysql_query($query);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_array($result)){&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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&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; &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; &lt;div class=&quot;toplist&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img src=&quot;<a href="http://www.habbo.nl/habbo-imaging/avatarimage?figure=&lt;?php" target="_blank">http://www.habbo.nl/habbo-imaging/avatarimage?figure=&lt;?php</a> echo $row['look']; ?&gt;&amp;size=m&amp;direction=3&amp;head_direction=3&amp;gesture=sml&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;toplist&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h1&gt;&lt;?php echo $row['username']; ?&gt;&lt;/h1&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;p&gt;&lt;?php echo $row['respects_received']; ?&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;[/spoiler]You see:$query = &quot;SELECT username, respects_received, look FROM users AND users_settings WHERE rank &lt; 7 ORDER BY respects_received DESC LIMIT 10&quot;;&nbsp; I'm trying to get that to display&nbsp; &nbsp; &lt;h1&gt;&lt;?php echo $row['username']; ?&gt;&lt;/h1&gt;&nbsp; &lt;p&gt;&lt;?php echo $row['respects_received']; ?&gt;&lt;/p&gt;Which shows the username, figure, then the other table which is called at &quot;AND users_settings&quot; for the respects.</blockquote>

[QUOTE="Kristopher, post: 388955, member: 1958"] So if you check the code below in the spoiler [spoiler] <?php $query = "SELECT username, respects_received, look FROM users AND users_settings WHERE rank < 7 ORDER BY respects_received DESC LIMIT 10"; $result = mysql_query($query); while($row = mysql_fetch_array($result)){ ?> <div class="toplist"> <img src="[URL]http://www.habbo.nl/habbo-imaging/avatarimage?figure=<?php[/URL] echo $row['look']; ?>&size=m&direction=3&head_direction=3&gesture=sml"> <div class="toplist"> <h1><?php echo $row['username']; ?></h1> <?php echo $row['respects_received']; ?> </div> [/spoiler] You see: $query = "SELECT username, respects_received, look FROM users AND users_settings WHERE rank < 7 ORDER BY respects_received DESC LIMIT 10"; I'm trying to get that to display <h1><?php echo $row['username']; ?></h1> <?php echo $row['respects_received']; ?> Which shows the username, figure, then the other table which is called at "AND users_settings" for the respects. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members