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