Welcome!

Join our community of MMORPG enthusiasts and private server developers! By registering, you'll gain access to in-depth discussions on source codes, binaries, and the latest developments in MMORPG server files. Collaborate with like-minded individuals, explore tutorials, and share insights on building and optimizing private servers. Join us today and unlock the full potential of MMORPG server development!

Join Today!

Selecting Ranks

Status
Not open for further replies.
Joined
Jun 27, 2009
Messages
1,574
Reaction score
175
Location
Niagara Falls,
I need this to select from ranks but I don't know what to remove I need it from rank 11

PHP:
<h2 class="title">Owners</h2>
								<div style="padding:5px">
								<?php
								$getRepsect = mysql_query("SELECT * FROM `user_stats` WHERE `Respect` >= '0' ORDER BY `respect` DESC LIMIT 5");
								$getRespectGiven = mysql_query("SELECT * FROM `user_stats` WHERE `RespectGiven` >= '0' ORDER BY `RespectGiven` DESC LIMIT 5");
								
								while(($Repsect = mysql_fetch_array($getRepsect)) && ($RespectGiven = mysql_fetch_array($getRespectGiven))) {
								  
								$getUserInfo = mysql_query("SELECT * FROM `users` WHERE `id` = '".$Repsect['id']."'");
								$userInfo = mysql_fetch_array($getUserInfo);

								$getUserInfo1 = mysql_query("SELECT * FROM `users` WHERE `id` = '".$RespectGiven['id']."'");
								$userInfo1 = mysql_fetch_array($getUserInfo1);
								  
								echo '
									<table style="width: 50%; float:left">
										<tr>
											<td width="20%"><img src="http://www.habbo.nl/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&size=s&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td>
											<td width="80%"><b><a href="/home">'.$userInfo['username'].'</a></b><br />'.$userInfo['motto'].'</td>
										</tr>
									</table>';
								}
								?>
								</div>
							</div>
						</div>
 
Status
Not open for further replies.
Back