SQL statement to get rid redundancy fields

Databases
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

it definitely is not done with SQL

please ask a moderator to move this to the php forum

:slight_smile:

3

Topic continued in PHP codes/SQL Statement to get rid redundancy fields