how to display a value in a column in the list if the value is repeating show only one time using mysql & codeigniter?

AB Tech

This is my requirement, If the value in a column is repeating then show only one time and blank for the next value comes.

this the first table

this is how to display

this is an example. Can anyone help me.

kuldeep
<table>
 <tr>
   <th>Title</th>
   <th>Name</th>
 </tr>

<?php $value=null;
foreach($view as $key){
 echo "<tr>";
 if($key['title']==$value){
    echo "<td></td>";
  }
 else{
    echo "<td>".$key['title']."</td>";
    $value=$key['title'];
  }
  echo "<td>".$key['Name']."</td>";
  echo "</tr>";
}
?>

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Display only one time a value from column's table

How to show integer value column to be string value in display using SQL

How to display the value within the column only and display it (PHP & MySQL)

How to show the array values using one matching value and display it as a table

List a column's value only once for repeating IDs

How to display one value for a one column in SQL?

How to use the Spread function using only one value of the target column?

How to Show a Value One Time in Loop

Incremental values how to show one value at a time

How to show and save only one value on Odoo?

Mysql Select to columns as one but display only one where value %like%

Repeating rows but changing column value each time

How to deal with a column with only one value?

How to return data from two tables only when the column value in one table is same as another table using MySQL?

How to concatenate values of repeating column value using pandas?

using array_unique in php codeigniter the returing only one value

How do I mutate a list-column to a common one leaving only the last value when there is a vector in the list?

Display only 5 li (list items) at one time using Jquery

MySQL select - If a column value is redundant, only show the newest by timestamp

How to display one element at a time from a list without repeating the same element in Python

How to display first time zero value if there is no value in database using php?

Only select one row with matches list column value

How do I advanced filter a column to show all values of a particular ID if this matching column only matches one value?

How to replace a value in one temporary column depending on another column mysql using SELECT

How to show array elements one at a time using only Javascript?

Show only column value; not column name in Yii

How to show ONLY the max value of a inner join table column?

How to display only one item at a time using JavaScript

how to show 2 value and one values count from 3 table using mysql