In PHP/MySQL 5 loops, to appear qeuries results, well can I nest queries ? [b]What so

[leonidassavvides]

In PHP/MySQL 5 loops, to appear qeuries results, well can I nest queries ? What solutions exist ? This is due to the fact that, I need data from first query to input continuously to second query ?

[borris83]

place a while loop inside a while loop... If u place an example code, then it will easy to tell you how to input data from first query to second query

[leonidassavvides]

Select * From $affTable;

$AID=row['AID'];
Select SUM(total) AS TOTAL From $bookingTable Where AID='$AID';

// HOW I GET EACH AFFID(=AID) FROM FIRST QUERY AND RUN SECOND QUERY TO LIST TOTAL EARNINGS(=TOTAL) ?

[borris83]

Hope this helps

$query = mysql_query("Select * From $affTable ");

while ($row = mysql_fetch_array($query))
 {
  $AID = $row['AID'];
  $query2 = mysql_query("Select SUM(total) AS TOTAL From $bookingTable Where AID='$AID' ");
  
    while  ($result = mysql_fetch_array($query2))
             {
              \\do whatever you want to do with the values here
    
             }
  
  
 }

[leonidassavvides]

The:
while ($row = mysql_fetch_array($query))
may be like:
$count = @mysql_num_rows($result);
while ($i < $count) {
???