PHP group results by first letter of name

Question

I have a query that receives all records sorted by last_name. Now I would like to create a loop that groups these results by the first letter of the last name and displays the letter above the group ie

A
-----------
Albert
Alfred

C
-----------
Charles

D
-----------
Delta etc...

Thank!

Answer 1

Order the results on lastnamethe side MySQLand track the change in the first letter on the side PHP:

<?php

$rs = mysql_query("SELECT * FROM mytable ORDER BY lastname");

while ($rec = mysql_fetch_assoc($rs)) {
    if ($initial !== strtoupper(substr($rec['lastname'], 0, 1)) {
        $initial = strtoupper(substr($rec['lastname'], 0, 1));
        print "$initial\n";
    }
    print $rec['lastname'] . "\n";
}

?>

Answer 2

$letter = null;
foreach ($array as $word) {
  if ($letter != $word[0]) {
    $letter = $word[0];
    echo '<b>'.strtoupper($word[0]) . '</b><br/>';
  }
  echo strtoupper($word) . '<br/>';
}

and in the line for adding a tour request:

order by `your_field` asc

Answer 3

- ?

$last = '';
foreach($data as $key=>$row){
    if(substr($row['last_name'],0,1)!=$last) echo '<br /><br />'.substr($row['last_name'],0,1).'<br />----------------<br />';
    $last = substr($row['last_name'],0,1);
    echo $row['last_name'];
}

Answer 4

:

$current = '';
foreach ($rows as $r) {
    if (!$current || strtolower($r['name'][0]) != $current) {
        $current = strtolower($r['name'][0]);
        echo strtoupper($current).'<br />---------------';
    }
    echo $row['name'].'<br />';
}

Answer 5

in your request, try adding something like:

group by substr(last_name,1,1)

i.e.

select substr(last_name,1,1) as alpha, *
from tableName
group by substr(last_name,1,1)

Answer 6

Yes, you can achieve this using MySql

In my case, market_name will be a list as you expected.

Example:

SELECT id, upper(SUBSTR(brand_name, 1, 1))  AS alpha FROM products WHERE  brand_name != ''  group by alpha
UNION
SELECT id, upper(SUBSTR(brand_name, 1, 1))  AS alpha FROM products WHERE  brand_name != '' order by brand_name COLLATE NOCASE

Result:

    A
    A Card
    A Cef
    A Cef O
    B
    Bacticef Tab
    Bacticin
    Bactidrox
    Bactidrox Kid
    ........

Hope this helps someone.