Re: echo diferent coluns from left join
| From: | Miles Thompson | Date: | Thu, 10 Jan 2002 17:16:27 +0000 |
| Subject: | Re: echo diferent coluns from left join | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-80053@lists.php.net to get a copy of this message | ||
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