Posted by Kenoli on 02/07/07 21:58

Suppose I have results from 2 queries each to a different table:

$result1 = (mysql_query($query1);

and

$result2 = (mysql_query($query2);

And I want to loop through both of them in order to put some values
from each in a table.

With one, I would do:

while ($row1 = mysql_fetch_array ($result1)) { etc.

<td><?=$row1['column1']?></td> etc.

Suppose I want the next cell to be:

<td><?=$row2['column1']?></td> //associated with $result2

How do I construct the "while" conditional to loop through both
queries????

The results are linked by a common column (person_id).

Thanks,

--Kenoili

--Kenoli

• Next in forum: Re: Looping through 2 query results
• Prev in forum: Re: max_connections exceeded
• Thread view: Looping through 2 query results

[Reply to this message]