[thelist] Re: another mysql order problem
DESCHAMPS Stéphane DvSI/SICoR
stephane.deschamps at francetelecom.com
Mon Feb 3 07:46:05 CST 2003
> -----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 ;-))
More information about the thelist
mailing list