Jump to content

How to make this into 1 query?


newbtophp

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/203697-how-to-make-this-into-1-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.