[thelist] Re: another mysql order problem

[DESCHAMPS Stéphane DvSI/SICoR]

> -----Message d'origine-----
> De : thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]De la part de Dunstan Orchard
>
> > From: "rudy" <r937 at interlog.com>
> > 1. never do a SELECT inside a loop -- the same results can
> usually be done
> > with a join
>
> really?
> damn, I always do that... it seems like JOIN is about the
> most useful thing to
> learn. I can't get my head round it. I think I have it, but
> then my examples
> hardly ever work. Ah well...
>
> Oh, well, sometimes I think I have to do a SELECT inside a
> loop because I have
> to assign variables at each stage. But ok, I get your point :o)
>
> *goes off to try to find some good articles on JOIN*

If you find interesting articles and examples that work (say, for instance in PHP/MySQL) I'd be happy to see you share what you found ;-)

(I can't seem to get the hang of JOINs in PHP/MySQL and still use several querys within PHP loops, although I know it's _bad_ according to rudy, who sounds right to think so, too ;-))