Re: [PHP-DB] Re: Problems with INNER JOIN

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 <[email protected]> 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
>
>