Edit: Sorry didn't see AlabamaHits post ^^
<?php
/*
* Made By: Djkanna.
*/
require_once (dirname (__file__) .'/globals.php');
$users = $db->query (
"SELECT u.`userid`, u.`username`, u.`level`, u.`hp`, u.`gang`, u.`location`, g.`gangname`, g.`gangPREF`, c.`cityname` FROM
`users` u LEFT JOIN `gangs` g ON `gangID` = u.`gang` LEFT JOIN `cities` c ON c.`cityID` = u.`location` WHERE ( c.`cityID` = ".$ir['location']." && u.`user_level` != 0 ) ");
echo'[img=/pickafight.jpg]
';
?>
<table width="100%" class="table">
<tr>
<th>Player</th><th>Status</th><th>Level</th><th>Posse</th><th>Options</th>
</tr>
<?php while ($u = $db->fetch_row ($users) ) : ?>
<tr>
<td><?php echo $u['gang'] != 0 ? "[".$u['gangPREF']."]".stripslashes(htmlentities($u['username'], ENT_QUOTES)) :
"".stripslashes(htmlentities($u['username'], ENT_QUOTES)); ?></td>
<td><?php echo $u['hp'] <= 1 ? "<span style='font-color: red;'>Unconscious</span>" : "<span style='font-color: green;'>Alive</span>"; ?></td>
<td><?php echo number_format($u['level']); ?></td>
<td><?php echo $u['gang'] != 0 ? "[url='gangs.php?action=view&ID=".$u[']".stripslashes(htmlentities($u['gangname'], ENT_QUOTES))."[/url]" :
"<span>No Posse</span>"; ?></td>
<td><?php echo $u['hp'] <= 1 ? "<span style='font-color: #999; text-decoration: line-through;'>Attack</span>" :
"[url='attack.php?ID=".$u[']<span style='font-color: red;'>Attack!</span>[/url]"; ?></td>
</tr>
<?php endwhile; ?>
</table>
<?php $h->endpage (); ?>
Try that.