hello i inserted data in to table A and get IDs from table A to table B in catid column like 1, 2, 3... so i want to print IDs values as per multiple ids on same row ,Here is my table and final output table
[upl-image-preview url=https://board.phpbuilder.com/assets/files/2020-01-14/1578989836-736965-tensess.png]
<?php
$sql = "SELECT t.tense_name, c.tenid, c.cat_name FROM tenses t, tensecategory c WHERE t.pktenseid=c.tenid";
$getcat = mysqli_query($conn, $sql);
$tenseinfo = [];
while ($row = mysqli_fetch_assoc($getcat)) {
if (!isset($tenseinfo[$row['tenid']])) {
$tenseinfo[$row['tenid']] = ['cat_name' => $row['cat_name'], 'tenses' => [$row['tense_name']]];
} else {
$tenseinfo[$row['tenid']]['tenses'][] = $row['tense_name'];
}
}
//var_dump($tenseinfo);
echo '<table>';
foreach ($tenseinfo as $catid => $data) {
echo '<tr><td>' . $catid . '</td>';
echo '<td>' . $data['cat_name'] . '</td>';
$tensesimpl = implode(', ', $data['tenses']);
echo '<td>' . $tensesimpl . '</td></tr>';
}
echo '</table>';
?>