[PHP] Making a Variable from different tables with Matching Db fields?

[Terion Miller]

Not sure if I'm wording this right, what I am trying to do is look in two
tables, match the ID to use to pull information....

Here's my code but it's not right, although it is picking up the user from
the session, I will also post what my variable debugging lists:

    $query = "SELECT  admin.AdminID, workorders.AdminID FROM admin,
workorders WHERE admin.UserName =   '".$_SESSION['user']."' ";
    $result = mysql_query ($query);
    $row = mysql_fetch_assoc ($result);

    echo $row['AdminID'];

    if ($row['ViewMyOrders'] == "NO") {
        header ("Location: Welcome.php?AdminID=$AdminID&msg=Sorry, you do
not have access to that page.");
    }

*Also tried this to pull just this persons orders:*

    $sql = "SELECT workorders.WorkOrderID , workorders.AdminID,
admin.AdminID FROM workorders, admin WHERE workorders.AdminID =
admin.AdminID ";
    $result = mysql_query ($sql);

Thanks for looking, t.