Top 5 Players in Citys

[Infamous cTz]

needing some help here... the code below isnt even close seeing how i cant organize by city...

something like WHERE $user_class->city ... im lost as you cant tell lol help me

 

[mysql]

<?php

$result = mysql_query("SELECT * FROM `grpgusers` WHERE `$user_class->city=` ORDER BY `exp` DESC LIMIT 5");

while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

$user_online = new User($line['id']);

echo "<div>".$user_online->id.".)".$user_online->formattedname."</div>";

}

?>

 

[/mysql]

[Zero-Affect]

I've not had GRPG but with basic mysql i'd so something like

    $query = mysql_query('SELECT `id`, `name` FROM `users` u LEFT JOIN `city` c ON c.`city` = u.`location` ORDER BY `column` DESC LIMIT 5')
  while ( $fetched = mysql_fetch_object($query) ) {
echo '
<div>
'.$fetched->name.' ('.$fetched->id.')
</div>
';
  }

[Infamous cTz]

[mysql]

<?php

$result = mysql_query("SELECT * FROM `grpgusers` WHERE `city = $user_class->city` ORDER BY `exp` DESC LIMIT 5");

while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

$user_online = new User($line['id']);

echo "<div>".$user_online->id.".)".$user_online->formattedname."</div>";

}

?>

[/mysql]

 

i dont understand why this wont work :(

[Zero-Affect]

$result = mysql_query('SELECT `id` FROM `grpgusers` WHERE `city` = '.$user_class->city.' ORDER BY `exp` DESC LIMIT 5');

[SlanderDesign]

<?php

include (DIRNAME(__FILE__) . '/header.php');

 

echo '<tr><td class="contenthead">List Of All Complaints</td></tr>

<tr><td class="contentcontent">';

 

$result = mysql_query("SELECT * FROM `grpgusers` WHERE ".$user_class->city." ORDER BY `exp` DESC LIMIT 5");

while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

echo "<div>".mysql_real_escape_string(strip_tags($line['id'])).". ".mysql_real_escape_string(strip_tags($line['username']))."</div>";

}

include (DIRNAME(__FILE__) . '/footer.php');

?>

this only works for the EXP not stat's.

Regards Linton.

PS: Sorry I forgot about making this for you!

[Jordan Palmer]

Lookup mysql_real_escape_string..

 

Linton..you need to visit thst :)

[SlanderDesign]

XD this is from my complaints mod...

Yeah no need for the mres ect, it did have text but it doesn't no more.

Remove it if you want, but it's causing no errors.

Regards Linton