[SOLVED] using a query inside of mysql_fetch_array while loop

[rbragg]

I have some results to a query called $firstResults and a while loop to display those results:

 

<?php 
while($row = mysql_fetch_array($firstResults))
{
  blah blah blah
} 
?>

 

This works fine. However, I would like to use the results of another query and display those within the above loop. Is this possible? Here is my second query:

<?php
$queryLast = "
SELECT MAX(actionID), name, subjectID, subject, msg, timestamp
FROM onetable
GROUP by subjectID
ORDER by timestamp DESC
";
$lastResults = mysql_query($queryLast) or die('This last query failed: ' . mysql_error()); 
?>

[artacus]

Sure it is. Just use different variables to store mysql_query() and mysql_fetch_array() values.

[rbragg]

Thanks for your reply. Wouldn't this require having a while loop INSIDE of another while loop?

[rbragg]

Thanks again - I figured it out.