newbtophp Posted June 2, 2010 Share Posted June 2, 2010 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 More sharing options...
DavidAM Posted June 2, 2010 Share Posted June 2, 2010 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 Link to comment https://forums.phpfreaks.com/topic/203697-how-to-make-this-into-1-query/#findComment-1066932 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.