Array Layout Help

[tobeyt23]

Ok I am having a brain fart and/or not enough coffee! See the below array:

Array
(
    [0] => Array
        (
            [breed_name] => Boxer
            [dog_name] => Fred
        )

    [1] => Array
        (
            [breed_name] => Labrador Retriever
            [dog_name] => Roxy
        )

    [2] => Array
        (
            [breed_name] => Labrador Retriever
            [dog_name] => Semper
        )

    [3] => Array
        (
            [breed_name] => Mixed Breed
            [dog_name] => Bronchito
        )

    [4] => Array
        (
            [breed_name] => Mixed Breed
            [dog_name] => Fonz
        )

    [5] => Array
        (
            [breed_name] => Mixed Breed
            [dog_name] => Triton
        )

)

I need to lay this out like so:

 

Boxer - Fred 
Labrador Retriever - Roxy, Semper 
Mixed Breed - Bronchito, Fonz, Triton

 

Any help would be appreciated as i am just banging my head currently!

[ginerjm]

If you stored this into a dbms table you could write a query to organize the data in any fashion you might need today and in the future. If this is meant to be any kind of static data, I highly recommend that you re-think your storage plan. Sure you can do this, but the better approach is as I am suggesting.

[tobeyt23]

these are in tables

[ginerjm]

Would have been nice if you mentioned that.

 

Do your query to order the results by breed. Then loop thru the results echo'ing the breed and name on the first record. Then on the following records echo the name until you see a change in breed at which time you begin a new row with the breed name and the new dog name. And repeat. You'll have to save the 'last-breed' name after each record and use it to compare against the next record every time.

 

A very common approach to your problem.

[ginerjm]

Feeling magnanimous today:

$q = 'select breed_name, dog_name from dogs_table
order by breed_name';
$qrslts = $pdo->query($q);
if (!$qrslts)
{
echo "Could not execute query";
exit();
}
$last_breed = 'xxx';
while(list($breed, $name) = $qrslts->fetch(PDO::FETCH_NUM))
{
if ($breed <> $last_breed)
{
if ($last_breed <> 'xxx')
echo '<br>';
echo "$breed - $name";
}
else
echo ", $name";
$last_breed = $breed;
}

 

 

(too bad the forum doesn't recognize the tabs in this code.)

Edited March 28, 2017 by ginerjm

[tobeyt23]

Thanks