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