I WANT TO ECHO OUT DATA WITH THE SAME NAME BUT DIFFERENT DATA

[tosan ayodele]

Hello i need your help, im a php programmer and am having challenge echoing out multiple data with similar group name.I have two tables named groups and news, in my group i have columns named id, name. in my news table i have id, events name. Am trying to use the left join mysql query to echo out data with similar names. This is my code :

// Events
$sql = 'SELECT n.*, g.name FROM news AS n LEFT JOIN groups AS g ON n.name = g.name WHERE g.name = "'.$g.'"';
$query = mysqli_query($db_conx, $sql);
while($row = mysqli_fetch_array($query, MYSQLI_ASSOC)){
$events=$row['events'];
/*echo $row['events'];
echo "<br>";*/
}


<?php echo $events;?>