Re: Re: Problems with INNER JOIN

SELECT adminID FROM admin WHERE username=" $username " $adminid = mysql_fetch_row ... SELECT * FROM workorders WHERE adminid = $adminid Terion Miller napsal(a):

Yes I've already done that and checked the db etc and I've turned my brain ON hours ago, I came to the list because I'm stumped and have tried all manners of different ways to tell mySql if admin ID = session user then get workorders where orderID = admin ID .... On Thu, Jan 29, 2009 at 1:28 PM, Martin Zvarík <mzvarik@gmail.com <mailto:mzvarik@gmail.com>> wrote:

    Are you sure you have MORE than ONE [order + admin that belongs
    together] in those tables?

    Now, turn on your brain and don't wait for my instructions, you
    already know what to do... test test test

    Terion Miller napsal(a):
    When I removed the WHERE admin.user... part it did return
    something, granted it returned one adminID and one order (which
    did belong together) but the adminID was not mine so I don't know
    how it picked that one randomly ...is there a way to do what I
    need using two queries one to find out the users ID then another
    to pull the workorders with that id? Can't believe this is
    proving so hard..
    Thanks for helping!
    Terion

    On Thu, Jan 29, 2009 at 12:55 PM, Martin Zvarík
    <mzvarik@gmail.com <mailto:mzvarik@gmail.com>> wrote:

        What I wrote with HAVING doesn't do any difference - replace
        back to WHERE.

        Your query is OK.

        Try: echo mysql_error();

        And try to remove the condition "WHERE admin.user..." if that
        outputs anything.

        Martin

        Terion Miller napsal(a):

            Thanks Martin, oddly enough that still doesn't pull any
            results, it won't

            even print the variables if I try to list them to see, I
            know my db
            connection is good checked that, and can do really simple
            queries, would
            something be preventing a JOIN from working?
            When I Reveal my variables this query snippet:
               $sql = "SELECT admin.AdminID, workorders.WorkOrderID
            FROM admin
            INNER JOIN workorders ON admin.AdminID=workorders.AdminID
            HAVING admin.username='".$_SESSION['user']."' ";

                 $result2 = mysql_query ($sql);
                 $row2 = mysql_fetch_assoc ($result2);
                 $Total = ceil(mysql_num_rows($result2)/$PerPage);

            Returns this:
            $sql"SELECT admin.AdminID, workorders.WorkOrderID FROM
            admin INNER JOIN
            workorders ON admin.AdminID=workorders.AdminID HAVING
            admin.username='tmiller' "$result2""$row2""

            Terion

            On Thu, Jan 29, 2009 at 11:56 AM, Martin Zvarík
            <mzvarik@gmail.com <mailto:mzvarik@gmail.com>> wrote:

                This will work:

                $sql = "
                SELECT admin.AdminID, workorders.WHAT_YOU_WANT
                FROM admin
                INNER JOIN workorders ON admin.AdminID=workorders.AdminID
                HAVING admin.username='".$_SESSION['user']."'
                ";

                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 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

                --
                PHP Database Mailing List (http://www.php.net/)
                To unsubscribe, visit: http://www.php.net/unsub.php

        --         PHP Database Mailing List (http://www.php.net/)
        To unsubscribe, visit: http://www.php.net/unsub.php