Whats wrong with this ?

It works fine when i dont have the extra stuff to show the access_name

PHP 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;?>

---

yet

PHP Code:

---

      $sql = "SELECT  * FROM users"; 


---

worked.
When i use that... it doesnt show... yet i use something similar with another page.And it shows...

hmmm

You're missing a semi colon;

PHP Code:

---

<td><?php echo $row['id'] ?></td>

---

Please specifiy the problem though, do you get an error?

nvm fixed it.... i forgot to insert sum stuff...lol....my bad...

i had no errors. All it was was no inserted info into a table i was calling.

Quote:

---

Originally Posted by Dayjo

You're missing a semi colon;

PHP Code:

---

<td><?php echo $row['id'] ?></td>

---

Please specifiy the problem though, do you get an error?

---

That won't matter since its the only line inside of a code block

thats what i was trying to tell him... lol..

Its funny how a simple mistake. Can take HOURS to fix.