php mysql many to many relationship query result display

debugcn Published at Dev

ytse_jam

I'm just wondering if you can help me organize the query result from many to many relationship, below are other details.

here is my query:

SELECT rt.room_title as rm_name, amn.amnty_title FROM amenities_tbl AS amn LEFT JOIN room_am_link AS ral ON amn.amnty_id = ral.am_id LEFT JOIN rooms_tbl AS rt ON ral.rm_id = rt.room_id;

and here is my foreach loop on the query result (codeigniter):

<?php foreach($result as $row){?>
<tr>
<td><?php  echo $row['rm_name']; ?></td>
<td><?php echo $row['am_title']; ?></td>
</tr>
<?php } ?>

the display result is show below,

but what i want the display to be is like this image below, the room title is not repeated:

i'm sorry if my questions is very long, i just want it to be clear as much as possible.
thank you and hope you can help me guys.

Jerzyk

simple way of doing this is to have a variable, that will keep value of the item from the first column, then in loop, you are displaying it only if value will change, eg.:

<?php 
   $first_col = NULL;

   foreach($result as $row){ ?>
     <tr>
       <td><?php
             if ($first_col != $row['rm_name']) {
               echo $row['rm_name'];
               $first_col = $row['rm_name'];
             } else {
               echo "&nbsp;";
             }; ?>
      </td>
      <td><?php echo $row['am_title']; ?></td>
   </tr>
<?php } ?>

of course, your data should be sorted by this first column - you need to add ORDER BY to your SQL.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-19

Comments

0 comments

From Dev

Related Related

Article

php mysql many to many relationship query result display

php mysql many to many relationship query result display

MySQL, join many to many relationship query

Trying to display in a simple php system mysql data with One to many relationship?

Many to many relationship and MySQL

Mysql Many to Many relationship

Specific result in many to many relationship

PHP Query To Filter Many-To-Many MySQL

Query many to many relationship with DetachedCriteria

how to query a many to many relationship?

eloquent: query many to many relationship

How to query for many to many relationship between products and filters in MySQL?

How to query a pivot table data in MySQL (many to many relationship)

denormalize many to many relationship in MySQL

JPA criteria query in a many-to-many relationship

Parse - Array of pointers - Many to Many relationship query

CoreData: Query to one-to-many-to-many relationship

Many-to-many relationship query alright?

Advanced SQLite query on many-to-many relationship

Laravel Many to Many query relationship with where clause

Hibernate query on many to many relationship with extra column

JPQL query with many-to-many relationship

ios parse one query many to many relationship

Linq Query relating Many to Many relationship

Many to Many relationship query. Laravel

query over many to many relationship in redbeanphp

Laravel Many to Many query relationship with where clause

Unable to query over many-to-many relationship

HQL query for Many to Many Explict relationship

Single SQL query on many to many relationship

Laravel many-to-many relationship query