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

Yep they both work separately ... can't believe I've been stuck on the same
thing all day, it seems like an easy thing...

On Thu, Jan 29, 2009 at 5:09 PM, Chris <[email protected]> wrote:

> Terion Miller wrote:
>
>> Actually I have tried EVERYTHING suggested and it just does not work, in
>> my last query here I put in a user I know has orders and still nothing :
>>
>> $sql3 = "SELECT admin.AdminID, workorders.WorkOrderID,
>> workorders.DATE_FORMAT(CreatedDate,'%m/%e/%y') AS SubmitDate,
>> workorders.Location, workorders.AdminID, workorders.FormName,
>> workorders.Status FROM admin INNER JOIN workorders  ON admin.AdminID =
>> workorders.AdminID WHERE admin.username = 'lhanford' ";
>>
>> Are there mySQL settings that could prevent JOINS?
>>
>
> Definitely not.
>
> Try it manually in two parts:
>
> select adminID from admin WHERE username='lhanford';
>
> remember that id, then:
>
> select * from workorders where adminID='admin_id_from_last_result';
>
> Any results?
>
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>