排序结果mysql / php

Question

Lets say i have a list full of phones. It's easy to print all the phones out in a unordered list like:

$get_phones = $mysqli->query("
SELECT
    a.id,
    b.phone_id,
    a.phonename AS pname,
    b.modelname AS mname,
FROM phone_brands 
a LEFT OUTER JOIN phone_models b
ON a.id = b.phone_id");

while($phones = $get_phones->fetch_assoc()){
echo $phones['pname'] . $phones['mname'];}

But how can i make the list more readable by sorting all the models and phones like:

Iphone
3G
3GS
4G

Nokia
Lumia 1020
Lumia 925
Lumia 520

My guess is that i should do something like:

if($phones['pname'] == $phones['pname']{}

But i don't know if i'm far away here? Any help would be appreciated :)

Answer 1

Well ofcourse you could order the query by mname:

$get_phones = $mysqli->query("
SELECT
    a.id,
    b.phone_id,
    a.phonename AS pname,
    b.modelname AS mname,
FROM phone_brands 
a LEFT OUTER JOIN phone_models b
ON a.id = b.phone_id
ORDER BY mname");

And then in php do something like:

$currentModel = "";

while($phones = $get_phones->fetch_assoc()){
    if($currentModel != $phones['mname']){
        echo $phones['mname'].'<br/>';
        $currentModel = $phones['mname'];
    }
    echo $phones['pname'];
}