Re: [PHP] echo diferent coluns from left join

2002-01-10 Thread Miles Thompson
Two ways actually ... You could execute two separate SQL statements, and process them one after another. or You could process your result set, echo()'ing or print()'ing the first elements of the result set, then go back to the beginning and do the second set, something like this ... for ($i

Re: [PHP] echo diferent coluns from left join

2002-01-10 Thread Rodrigo Peres
Sorry, Ithink that I not explain right. I nedd to create a list, something like: url site url site url_2 site_2 url_2 site_2 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 [EMAIL PROTECTE

Re: [PHP] echo diferent coluns from left join

2002-01-10 Thread Miles Thompson
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

[PHP] echo diferent coluns from left join

2002-01-10 Thread Rodrigo Peres
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, fanc