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