Re: echo diferent coluns from left join

Sorry, Ithink that I not explain right. I nedd to create a list, something like: url site <br> url site <br> url_2 site_2 <br> url_2 site_2 <br> When the values returned by url and site finished them proceed to url_2 and site_2 values. Thank's Rodrigo on 1/10/02 3:16 PM, Miles Thompson at milesthompson@ns.sympatico.ca wrote: > > If I understand you correctly, use Javascript to open a second browser > window for url_2. > > Miles Thompson > > At 02:49 PM 1/10/2002 -0200, Rodrigo Peres wrote: >> Dear List, >> >> I have this sql command that grabs a result of 3 tables. What i want is if >> there's a way to do a while printing the site and url and after it's finish >> begin, printing site_2 and url_2. >> >> SELECT celebridades.*, links_relacionados.Nome_Link as >> site,links_relacionados.Url_link as url, fanclubes.Nome as >> site_2,fanclubes.Site as url_2 >> >> FROM celebridades LEFT JOIN links_relacionados ON >> links_relacionados.CelebID=celebridades.CelebID LEFT JOIN fanclubes ON >> fanclubes.CelebID=celebridades.CelebID WHERE celebridades.CelebID='$celebID' >> >> Thank's in advance >> >> Rodrigo Peres >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net >> For additional commands, e-mail: php-general-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net > --