MySQL Forums
Forum List  »  Newbie

Re: many to many LEFT JOIN
Posted by: Callum Macdonald
Date: July 11, 2005 09:00AM

Hi Kyle,

Not sure if this will help at all, but have you tried removing the second LEFT JOIN to see if it returns the correct results from the first join?

Should the second half ot he second ON clause read:
nis_project.id = '".$_GET['select_project'] . '"

Currently you've got the GET variable = to the project ID, should it be the project id = to the GET variable? Again, only a suggestion, not sure if it will help or not.

Good luck,


Callum.

Options: ReplyQuote


Subject
Written By
Posted
July 11, 2005 07:59AM
Re: many to many LEFT JOIN
July 11, 2005 09:00AM
July 12, 2005 07:23PM
July 11, 2005 09:06AM
July 13, 2005 01:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.