Problems with INNER JOIN

[email protected] (Terion Miller)
Newsgroups php.db
Message-ID <[email protected]>
Hi Everyone! I am having problems getting an INNER JOIN to work and need
some tips trouble shooting where the problem may be.

What I'm trying to do is match up AdminID's from two tables and display only
that users orders, sounds simple enough right...but I can't get it to return
the AdminID...

My Query:

   $sql =
     "SELECT admin.AdminID , workorders.AdminID
         FROM admin
             INNER JOIN
         workorders ON
          (admin.AdminID=workorders.AdminID)
         WHERE admin.UserName =   '".$_SESSION['user']."' ";


      $result = mysql_query ($sql);
      $row = mysql_fetch_assoc ($result);
      $Total = ceil(mysql_num_rows($result)/$PerPage);

Thanks for any tips on how else I can accomplish this...
Terion
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.