CODEWITHSUNDEEP
mysqlparent-child
Rick Bross
Rick Bross

Reputation: 1082

Sorting MySQL entries as child and parent

So I have one table and the columns are id, parent-id, and name.

Heres what shows up.

1 Web Design
- 5 Templates
- 6 Finished Websites
2 Graphic Design
3 Photography
4 Image Manipulation

from this:

while($row = mysql_fetch_array( $result )) {
 echo $row['id'] . " ";
 echo $row['name'] . "<br/ >";

 while($row = mysql_fetch_array( $result2 )) {
  echo "- " . $row['id'] . " ";
  echo $row['name'] . "<br/ >";
 }
}

how can i dynamically list all childern under their respective parents such as...

1 Web Design
- 5 Templates
- 6 Finished Websites
2 Graphic Design
- 7 T-Shirts
- 8 Logos
3 Photography
- 9 Portraits
- 10 Nature
- 11 Animal
- 12 Architecture
4 Image Manipulation

Upvotes: 1

Views: 398

Answers (2)

m1k3y3
m1k3y3

Reputation: 2788

function items($parent_id)
{
    $query = "SELECT * FROM mytable WHERE parent_id = $parent_id"

    $result = mysql_fetch_array(mysql_query($query))

    foreach ($result as &$res)
    {
        echo $res['id'] . " ";
        echo $res['name'] . "";
        echo items($parent_id)
    }
}

Upvotes: 0

Rick Bross
Rick Bross

Reputation: 1082

Nevermind, got it....

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM `portfolio-categories` WHERE `parent-id` ='0'")
or die(mysql_error());

// keeps getting the next row until there are no more to get

$parent = 0; 

while($row = mysql_fetch_array( $result )) {
    echo $row['id'] . " ";
    echo $row['name'];

    $parent += 1;
    echo "#" . $parent . "#";

    echo "<br/ >";

    $result2 = mysql_query("SELECT * FROM `portfolio-categories` WHERE `parent-id`=$parent")
or die(mysql_error());

    while($row = mysql_fetch_array( $result2 )) {
        echo "- " . $row['id'] . " ";
        echo $row['name'] . "<br/ >";
    }
}

Upvotes: 1

Related Questions