모든 ca_id=10, ca_id=20, ca_id=30 .... 를 출력하고 싶습니다.

<?php

$sql = "select * from g5_shop_category where length(ca_id) = 2 order by ca_id asc"; // 1차 카테고리만 가져옵니다.

$result = sql_query($sql);

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

    echo "<div><h2>".$row['ca_name']."</h2>";

    $sql2 = "select * from g5_shop_category where length(ca_id) = 4 and ca_id like '{$row['ca_id']}%' order by ca_id asc";

    $result2 = sql_query($sql2);

     while ($row2 = sql_fetch_array($result2)) {

         echo "<div><h2>".$row2['ca_name']."</h2>";

         $sql3 = "select * from g5_shop_category where length(ca_id) = 6 and ca_id like '{$row2['ca_id']}%' order by ca_id asc";

         $result3 = sql_query($sql3);

         while($row3 = sql_fetch_array($result3)) {

              echo "<p>".$row3['ca_name']."</p>";

         }

         echo "</div>";

    } 

    echo "</div>";

}