It works fine when i dont have the extra stuff to show the access_name
yetPHP Code:<?php
$sql = "SELECT a.access_lvl as accesslvl, a.access_name as access_name, ".
"u.username as username, u.id as id, u.email as email, u.status_lvl as status_lvl ".
"FROM users u ".
"JOIN site_access_lvls a " .
"ON u.status_lvl = a.access_lvl " .
"ORDER BY id DESC";
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)):?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['username']; ?></td>
<td><?php echo $row['email']; ?></td>
<td><?php echo $row['access_name']; ?></td>
<td><?php echo ''; ?></td>
</tr>
<?php endwhile;?>
worked.PHP Code:$sql = "SELECT * FROM users";
When i use that... it doesnt show... yet i use something similar with another page.And it shows...
hmmm




Reply With Quote