Trim field to display a header for each letter.

[ljschrenk]

Hi there,

Here's a question my friend had. I gave him a solution but was wondering if there was an easier or quick way to solve this:

Thanks in advance for any help!!

Lisa Schrenk

---

i have a page which outputs data from a table organized by the business name so its in alphabetical order by busiinsess name .....whenever the business name no longer starts with A and goes on to B for example I want to display a big 'B,' or 'C' ect when that happens

[jcantrell]

This may not be the cleanest way, but here is how I would probably do it.

$lasttitle = "";
$sql = "SELECT * FROM table";
while ($a_row =mysql_fetch_array($sql)
{
$title = substr($a_row[business_name],1); // Get the first letter from the name
$title = strtoupper($title); //This will make the first letter capital.
if ($title != $lasttitle)
{
print "$title";
}
print "$a_row[business_name] and whatever other information will go here"
$lasttitle = $title;
}

Haven't tested this, but it should work. I think I do it a few other ways at work, if this isn't what you are looking for let me know, and I will get my code from work for you.

JAKE

[ljschrenk]

Thanks so much Jake!! That's exactly what I was looking for. It also gave me a chance to prove to him just how great these forums are. 🙂

Thanks again for your help.

Lisa