Menu
Community /Pin to ProfileBookmark
@NogDogMar 29.2011 — #I would probably dump it into a 2-D array, then use that to display it. (I'm not claiming it's a better way, just the way I like to do it. ? )
Sectioning Data By 1st letter
Hi,
I’m retriving a bunch of products from a database, ordered alphabetically in my query. But when I echo out the list of products, I want to do this…
[code=php]
<?php
$result = mysql_query(“SELECT * FROM products ORDER BY prod_name ASC”) or die (mysql_error());
while ($row = mysql_fetch_array($result))
{
echo $row[‘prod_name’].'<br />’;
}
?>
this outputs…
[QUOTE]
aprod1
aprod2
aprod3
bprod1
bprod2
bprod3….
I would like this….
[QUOTE]
A
aprod1
aprod2
aprod3
B
bprod1
bprod2
bprod3….
Hoping someone can advise me how!
Thanks in advance
Smithster
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogMar 29.2011 — #I would probably dump it into a 2-D array, then use that to display it. (I'm not claiming it's a better way, just the way I like to do it. ? )[code=php]
$result = mysql_query("SELECT * FROM products ORDER BY prod_name ASC") or die (mysql_error());
$data = array();
while ($row = mysql_fetch_array($result))
{
$data[substr($row['prod_name'], 0, 1)][] = $row;
}
foreach($data as $letter => $group)
{
echo "<h3>$letter</h3>n<ul>n";
foreach($group as $item)
{
echo "<li>".$item['prod_name']."</li>n";
}
echo "</ul>n";
}
[/code]