Try this:
$sql =
SELECT admin.AdminID AS adminID, workorders.AdminID AS workadmin
FROM admin
INNER JOIN
workorders ON
(admin.AdminID=workorders.AdminID)
WHERE admin.UserName = '.$_SESSION['user'].' ;
maybe you have to call with different name
Maybe LEFT instead of INNER?
Terion Miller napsal(a):
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
Terion Miller wrote:
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