How to make this into 1 query?

[newbtophp]

Hi. Im currently looping twice due 2 two queries, would it be possible to make this 1 loop, id assume it may be achieved if the 2 queries were to combine somehow?  :-\

 

<?php
$username = "admin";
$result = mysql_query("SELECT * FROM profile_comments WHERE comment_name = '{$username}' GROUP BY comment ORDER BY id DESC LIMIT 5");

if (mysql_num_rows($result))
{
while ($row = mysql_fetch_array($result))
	{
	$result_2 = mysql_query("SELECT * FROM site_users WHERE user_username = '{$row['profile_name']}' LIMIT 5");
	while ($row_2 = mysql_fetch_array($result_2))
		{
		$user_id = $row_2['user_id'];
		$date = $row['posted'];
		$comment = $row['comment'];
		$username = $row['profile_name'];
		echo $date . "<br />";
		echo $username . " - " . $user_id . "<br />";
		echo $comment;
		}
	}
}
  else
{
echo "None to display.";
}

?>

 

Appreciate help.

[DavidAM]

The query would look something like this:

 

SELECT c.id, c.posted, c.comment, c.profile_name, u.user_id
FROM profile_comments c JOIN site_users u 
  ON u.user_username = c.profile_name
ORDER BY c.id DESC LIMIT 5