MySQL Forums
Forum List  »  Newbie

Re: Query advice - Multiple LEFT JOINS to same table or not??
Posted by: Joby Tyler
Date: March 29, 2005 04:14PM

Thanks for sticking with me on this Chris - typical of me to land this as my first php/mysql web dev project!!

The DBI script / CONNECT by PRIOR is all a bit over my head I think - I don't want to complicate things too much.

Regarding returning the results on 2 rows - I think is going to be tricky to work into my PHP loops due to the way things are echo'd to the screen (there is a second loop listing available stock after each pair) and I'm not really sure how to change this.

To be honest, if its not a real no-no then I think I'll go for it using the 14 left joins and see how it performs - if this doesn't work very well, I guess I'll query the pairs table as the initial query and then have single queries within my PHP loops to get the 2 separate birds details as we've already discussed.

I'll keep the thread posted with my progress........

Options: ReplyQuote




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.