Results 1 to 5 of 5

Thread: Whats wrong with this ?

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member PlaGuE's Avatar
    Join Date
    Jun 2005
    Location
    in ur mind.
    Posts
    445

    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
    Last edited by PlaGuE; Jan 7th, 2006 at 09:40 PM.
    Without balance, there could only be chaos.
    Without chaos, there could be no balance.
    I live with karma. Eat with destiny. Dream of life without shackles....
    Yet. If life had no consequences, life could not exist, nor could it flourish.


    If at first you dont succeed.You're screwed.

    C++/Java NOOB.

    I aint a professional at PHP, but if i can help i will.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width