PHP Mysql Data Arrangement

Ca开发者_运维问答n anyone help me on how to do this

All the data should come from database and arrange like what has show above.Thanks..

How is this data stored, exactly?

You would ultimately order by the business name and every time a new first character came up, print that as a title.

$get_businesses = mysql_query("SELECT * FROM businesses ORDER BY name ASC");

$last_character = '';
while($res_businesses = mysql_fetch_assoc($get_businesses))
{
    $business_name = $res_businesses['name'];
    $first_character = strtolower( sub_str($business_name, 0, 1) );

    if($first_character !== $last_character){
        print '<h1>'.strtoupper($first_character).'</h1>';
    }

    print '<p>'.$business_name.'</p>';

    $last_character = $first_character;
}

If it's from your array

$last_character = '';
foreach($businesses as $business)
{
    $business_name = $business['name'];
    $first_character = strtolower( sub_str($business_name, 0, 1) );

    if($first_character !== $last_character){
        print '<h1>'.strtoupper($first_character).'</h1>';
    }

    print '<p>'.$business_name.'</p>';

    $last_character = $first_character;
}

It's ultimately untested but hopefully it'll give you what you need :)

This is a concept not the full code !

//connect to database

$sql="SELECT * FROM ORDER BY DESC";

$result=mysql_query($sql);

while($row=mysql_fetch_array($result)){

//write a dynamic table here

echo "< table > < td >";

if($row['name'] == 'Letter name') //the first letter then go to a new column < br >

}

echo "< /table >";