group "area" value per every record

[joon]

First I am using mySQL.

data in myTable
(ID)[category]{area}
(1) [1] {America}
(2) [2] {France}
(3) [1] {New York}
(4) [4] {Germany}
(5) [2] {Paris}
(6) [6] {Japan}
(7) [1] {L.A.}
(8) [4] {Berlin}
(9) [6] {Tokyo}

target resutl
(ID)[category]{area}
(1) [1] {America}
(2) [2] {France}
(3) [1] {AMERICA}
(4) [4] {Germany}
(5) [2] {FRANCE}
(6) [6] {Japan}
(7) [1] {AMERICA}
(8) [4] {GERMANY}
(9) [6] {JAPAN}

I have the above data in myTable and I like to produce the target result.
How can I do that?

[TTT]

$q = "SELECT id,category,area FROM table ORDER BY id ASC";

$arr = array();
$a=0;
while($rs = mysql_fetch_row($q)) {
   $arr[$a][0] = $rs[0];
   $arr[$a][1] = $rs[1];
  $arr[$a][2] = $rs[2];
 $a++;
}

for($a=0;$a<count($arr);$a++) {
     if($arr[$a][1] != $arr[$a][0]) {
          $key = $arr[$a][1];
          $c = strtoupper($arr[$key][2]);
        echo "id".$arr[$a][0]." cat".$arr[$a][1]." name ". $c;
      } else {
          echo "id".$arr[$a][0]." cat".$arr[$a][1]." name ". $arr[$key][2];
       }

}