Okay, I've toyed with this and it seems you either get all (inactive and active users) on a list or you get none at all... I'm trying to split them and it's not being nice about it. I've even made a new field in the MySQL table. Basically, it looks a little something like this..
[PHP]
<?php
session_start();
include ('user_conn.php');
$x=$_SESSION['xcoord'];
$y=$_SESSION['ycoord'];
$z=$_SESSION['zcoord'];
$checklocal=mysql_query("SELECT *
FROM `user_table`
WHERE `ns`='$x'
AND `ew`='$y'
AND `ud`='$z'
AND `active`='1'");
$checkarray=mysql_fetch_array($checklocal);
while ($checkarray=mysql_fetch_array($checklocal)) {
echo $checkarray['cn']." is here<br>";
}
?>[/PHP]