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 <dmagick@xxxxxxxxx> 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/ > >
