PHP codes/SQL Statement to get rid redundancy fields

PHP
1

I have a SQL query statement using PHP that produces the following result:

NAME FOODS

Ben Pizza
Ben Fries
Ben Choco
Kelly Fries
Chit Pizza

But what I want to view is like this:

NAME FOODS

Ben Pizza
___ Fries
___ Choco
Kelly Fries
Chit Pizza

*Replace the underscores with spaces

Just want to get rid the redundancy. Please help to come up with an SQL statement or PHP codes. Thank you. :slight_smile:

2

Hereā€™s a quick ā€˜stabā€™ at it. :slight_smile:


<?php
$array = array(
  array(
    'name'  => 'Ben',
    'food'  => 'Pizza',
  ),
  array(
    'name'  => 'Ben',
    'food'  => 'Fries',
  ),
  array(
    'name'  => 'Ben',
    'food'  => 'Choco',
  ),
  array(
    'name'  => 'Kelly',
    'food'  => 'Fries',
  ),
  array(
    'name'  => 'Chit',
    'food'  => 'Pizza',
  ),
);

class SomethingIterator extends ArrayIterator{
  protected
    $previousName = null;
  
  public function current(){
    $current = parent::current();
    
    if($this->previousName === $current['name']){
      $current['name'] = '';
    }else{
      $this->previousName = $current['name'];
    }
    
    return $current;
  }
}

foreach(new SomethingIterator($array) as $user){
  print_r($user);
}
/*
  Array
  (
      [name] => Ben
      [food] => Pizza
  )
  Array
  (
      [name] => 
      [food] => Fries
  )
  Array
  (
      [name] => 
      [food] => Choco
  )
  Array
  (
      [name] => Kelly
      [food] => Fries
  )
  Array
  (
      [name] => Chit
      [food] => Pizza
  )
*/
?>
3

I used a sql statement:

$sql = ā€œSELECT name, foods FROM peopleā€

$result=mysql_query($sql);

and inside the <td>

<td>
<?php
//Header in the .xls file
$_SESSION[ā€˜report_headerā€™]=array(ā€œNameā€,ā€œFoodsā€);

					//Table header
					echo "&lt;table id='box-table-a'&gt;";
					echo "&lt;thead&gt;&lt;tr&gt;&lt;th scope='col'&gt;Name&lt;/th&gt;&lt;th scope='col'&gt;Foods&lt;/th&gt;
					&lt;/tr&gt;&lt;/thead&gt;";
					
					$i=0;
					
					//Generate data from query
					while($row = mysql_fetch_array($result))
					{
						echo "&lt;tbody&gt;&lt;tr&gt;&lt;td&gt;"; 
						echo $_SESSION['report_values'][$i][0]=$row['0']; 
						echo "&lt;/td&gt;&lt;td&gt;";
						echo $_SESSION['report_values'][$i][1]=$row['1']; 
						echo "&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;";
						
						$i++;
					}
					
					echo "&lt;/table&gt;";
					
					//Close database
					mysqli_close($con);
				?&gt;
				&lt;/td&gt;
4

to accomplish what you want in the php, you must have an ORDER BY clause in your query

5

Itā€™ll just rearrange the names but not delete the redundant names in view using PHP.

ORDER BY will just result in:

Ben Pizza
Ben Fries
Ben Coke
Mary Pizza

Not:

Ben Pizza
(space) Fries
(space Coke
Mary Pizza

6

actually, you ~do~ need ORDER BY

otherwise you could get this ā€“

Ben Pizza
Mary Pizza
Ben Fries
Ben Coke

and that wonā€™t look right after being processed by php ā€“

Ben Pizza
Mary Pizza
Ben Fries
____ Coke

7

Yeah. After Order By? Whatā€™s next to get rid the redundant? :slight_smile:

8

the trick isnt to get rid of the redundant inside the query, itā€™s to ignore the redundant when youā€™re outputting.
Store the ā€˜currentā€™ personā€™s name as a variable, and as youā€™re walking through the results, only display the name when it changes.

9

From what you told, I added some codes:

//Header in the .xls file
$_SESSION['report_header']=array("Name","Foods");

//Table header
echo "<table id='box-table-a'>";
echo "<thead><tr><th scope='col'>Name</th><th scope='col'>Foods</th>
</tr></thead>";

$i=0;

//Generate data from query
while($row = mysql_fetch_array($result))
{
echo "<tbody><tr><td>"; 
$namep = $row['0'];
$_SESSION['report_values'][$i][0]=$namep;
							
if ($namep=$namep) {
echo "";
} else {
	echo $namep;
}
							
echo "</td><td>";
echo $_SESSION['report_values'][$i][1]=$row['1']; 
echo "</td></tr></tbody>";
							
$i++;
}
echo "</table>";

But it canā€™t seem right because the Name didnā€™t show at all now.

help

10

if ($namep=$namep) {

does this not strike you as wrong?

if (TheStoredName != TheCurrentRowsName) {
TheStoredName = TheCurrentRowsName;
echo TheCurrentRowsName;
}

11

sorry. iā€™m not good in programming. actually, the most hated subject. haha. kidding! itā€™s just that iā€™m not good on it. (: just doing it for a projectā€¦ T_T sigh XD

12

Where will i get the variable TheStoredName and TheCurrentRowsName?
The row[ā€˜nameā€™] will be passed into a variable like $TheStoredNameā€¦
How about the TheCurrentRowsName? row[ā€˜nameā€™] too?
May I know the code construction? :x

sowee. really donā€™t know anything about codingsā€¦ :sick:

13

TheCurrentRowsName = $row[ā€˜nameā€™]
TheStoredName = another variable; could be anything.

Basically what the code does is that if the stored name is not the same as the current name (IE: Whenever it changes), it outputs the new personā€™s name, and then sets the stored name as the current one, so that the next time through the loop, if the name hasnt changed, it doesnt print out the name.