0

In MySQL database I have 3 columns: Category, Name and Phone. Table looks like this example:

Work       David     777444555
School     Susan     776457333
Work       Peter     743234556
Work       Diana     765432456
Hockey     Ben       786432567
School     Tom       765434566
School     John      765457865
etc...

So how to do a "tree" outcome with PHP from this table (sort from A to Z)? I need something like this example:

Hockej:
 - Ben, 786432567
 - etc.
School:
 - John, 765457865
 - Susan, 776457333
 - Tom, 765434566
Work:
 - David, 777444555
 - Diana, 765432456
 - Peter, 743234556
Gergo Erdosi
  • 40,904
  • 21
  • 118
  • 94
Dartin
  • 1

2 Answers2

0
SELECT category,
       GROUP_CONCAT(CONCAT(Name, ', ', Phone) ORDER BY Name SEPARATOR ';' ) Names
FROM
    yourtable
GROUP BY category
Gervs
  • 1,397
  • 9
  • 8
0

I wrote this code and it seems to work, but please check it, if there is no mistakes that could make troubles :-)

$DBSERVER = 'server';
$DBUSER = 'user';
$DBPASS = 'password';
$DB = 'database';

$login = mysql_connect($DBSERVER, $DBUSER, $DBPASS) or die("Could not connect: " . mysql_error()); 
mysql_select_db($DB, $login) or die ('Can\'t use database : ' . mysql_error()); 
mysql_query("SET NAMES UTF8");



$query = "SELECT * FROM tree ORDER BY category, name"; 
$result = mysql_query($query); 

if(!$result){ 
  echo  mysql_error() . " - " . mysql_errno(); 
} 

else{ 
  $memory = '';
  while ($row = mysql_fetch_assoc($result)){
    if ($row['category'] != $memory){
      $memory = $row['category'];
      echo "<b>".$memory."</b><br>";
    }
    echo " - ".$row['name'].", ".$row['phone']."<br>";
  }
}

Is this code okay without mistakes?

Dartin
  • 1