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

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/