Hierarchical Data in a Relational Database

Posted by teejay on March 10, 2009

A Google Search would produce "30,800,000". There are quite a few people looking for a solution to hierarchical data queries.

I, myself have been looking through it for a while and ended up using the The Adjacency List Model due to the need of my data to be updated once in a while.

Here's the function I used for those in need of a similar function:

function _get_structure($parent = 0, $level = 0)
{
 $this->db->where(array('parent_kb_category' => $parent));
 $query = $this->db->get('categories');
  
 if ($query->num_rows() > 0)
 {
  $result = $query->result();

  foreach ($result as $category)
  {
   $id = $category->parent_kb_category;
   echo str_repeat('_', $level), $category->name;
   $this->_get_structure($category->id, $level+1);
  }
 }
}

Resources:

Categories: How To, Web Development

Tags: codeigniter, sql, php

12 Comments

gucci

linda
It’s the most important part of our marketing Tiffany & Co,” he said. “I absolutely cannot imagine a retailer or designer operating today without a website.We have a social media prada store who has helped us integrate our Facebook page with our blog, the website and Twitter, and it has definitely brought in clients,” Gucci Shoes Sale said. “Our big thing right now is video, though. We can take our clients to market with us via the clips we bring back and share on our video Nike Air Jordan. We’ve also found great success with Flowtown, a pay-for tool that lets you import your email list and see who’s on Twitter, chanel bags, LinkedIn - then aggregate them based on how they describe themselves.

August 13th 2010

eastnike

well,the following i will do a introduce about the popular shoes:
air jordan force 9
nike air jordan force 9
air jordan force IX LS
nike air max skyline
air max skyline
cheap air max skyline
airmax skyline
nike air max lebron 7
air max lebron 7
air max lebron VII
nike air max+2009
nike air max+2010
nike air max 90 shoes
nike air max 90 kids
nike air max 93 shoes
nike air max 95 shoes
nike air max 87 shoes
nike Air Max 1 premium
nike air max run lite
nike air max 89 shoes
nike air max 97 shoes
air max 97 shoes

nike womens
nike women’s shoes
nike women’s running shoes
nike kids shoes
nike kids
nike kids running shoes

puma cat shoes
puma ferrari
puma men shoes
puma ferrari shoes
puma ferrari cat
air max ltd
air max skyline
nike free running
cheap puma shoes
Nike Air Jordan
Nike Air Force 1
Nike Air Max
Nike Shox
Nike Free
Nike Dunk
Nike Basketball
Nike Shoes
Nike Women Shoes
Puma Shoes

We are a professional and reliable supplier of series of innovative, authentic and inexpensive Nike shoes with original box and retro card.
air max 2009
air max 2009 shoes
air max shoes sale
air max shoes
nike air max 2009
cheap air max 2009
buy air max 2009
air max 2009 review
airmax 2009
nike air max+2009
airmax shoes
air maxs
air maxes
air max
nike air max

warmly welcome and sincerely thank you for visiting our NikeShoes123 website.
the following is the hot sale on our website:
Nike air force 1 shoes
air force 1 shoes
air force 1 shoes sale
air forces
air force shoes
nike air force
nike air force shoes
1 shoes
af1 shoes
air force 1
air force 1 shoe
air force 1 high
air force 1 low
air force 1 mid
air force 1 sneaker
air force 1’s
air force one
air force one low
air force one shoes
air force one shoe
air force one sneaker
air force one high
air force one mid
air force one for sale
air forces shoes

August 18th 2010

weifeng

hollister uk
hollister
hollister clothing
hollister clothes
hollister london
hollister sale
hollister outlet
hollister online

August 23rd 2010

phoebe

The replica Chopard Happy Sport watches are considered a status symbols by many in the general public and the largest single luxury watch brand by far, itscopied.com offer you a large verity of our top quality replica Chopard Happy Sport watches with only a mere fraction of the actual price. The replica Rolex watches has become one of the most sought after watches of all time so when you are buying one of our luxury Replica Chopard Happy Sport watches you will receive quality and status in one package.
Cartier Pasha Replica
Breitling Aerospace Replica Watches
Franck Muller Casablanca Replica
Cartier Ballon Bleu Replica Watches

August 24th 2010

ugg boots

Michael Jeffrey Jordan (born February 17, 1963) is a former American professional basketball player, active businessman kids jordans, and majority owner of the Charlotte Bobcats. His biography on the National cheap jordans Association (NBA) website states, “By acclamation, Michael Jordan is the greatest basketball player of all time.”[1] Jordan was one of the most effectively marketed athletes of his generation and was instrumental in popularizing the NBA around the world in the 1980s and 1990s.

After a standout career at the University of North Carolina at Air Jordan 2010, where he led the Tar Heels to a National Championship in 1982,Jordan retro joined the NBA’s Chicago Bulls in 1984. He quickly emerged as a league star, entertaining crowds with his prolific scoring. His leaping ability, illustrated by performing slam dunks from the free throw line in slam dunk contests, earned him the nicknames “Air Jordan” and “Jordan retro”. He also gained a reputation for being one of the best defensive players in Air Jordan Retro.[2] In 1991, he won his first NBA championship with the Bulls, and followed that achievement with titles in 1992 and 1993, securing a “cheap jerseys”. Although Jordan abruptly retired from basketball at the beginning of the 1993–94 NBA season to cheap nikes a career in baseball, he rejoined the Bulls in 1995 and led them to three additional championships (1996, 1997, and 1998) as well as an NBA-record 72 regular-season wins in the 1995–96 NBA season. wholesale nikes retired for a second time in 1999, but returned for two more NBA seasons in 2001 as a member of the Washington Wizards.

Jordan’s individual Cheap Jeans and accomplishments include five MVP awards, ten All-NBA First Team designations, Cheap Jordansnine All-Defensive First Team honors, fourteen NBA All-Star Game appearances, three All-Star Game MVP awards, ten scoring titles, three steals titles,cheap uggs six NBA Finals MVP awards, cheap jordans and the 1988 NBA Defensive Player of the Year Award. He holds the NBA records for highest career regular-season scoring average (30.12 points per game) and highest career playoff scoring average (33.45 points per game). In 1999,boots shoes was named the greatest North American athlete of the 20th century by ESPN, and was second to Babe Ruth on the Associated Press’s list of athletes of the century. He was elected to the Basketball Hall of Fame on April 6, 2009 and was inducted on September 11, 2009.[3]

Jordan is also noted for his product endorsements.cheap shirts fueled the success of Nike’s Air Jordan sneakers, which were introduced in 1985 and remain popular today.[4] Jordan also starred in the 1996 feature film Space Jam as himself.polo shirts is the majority owner and head of basketball operations for the NBA’s Charlotte Bobcats; he recently won a bidding war to buy controlling interest in the team from founding owner Robert L. Johnson ed hardy.

August 25th 2010

william

The best 220-601 Exam practice exams just got better with actual MCTS practice questions accompanied by the real MCSE 2003 practice test answers. You are guaranteed to pass your Microsoft MCITP Certification exams with ActualAnswers MCSE 2003 exam papers. No other Microsoft 70-680 Exam study guide can prepare you or give you the 100% guarantee that you will pass your CompTIA Security+ Certification and know the solutions behind MCSE 2003 answers.

August 25th 2010

timberland boots

my website is special designed for you Cheap timberland shoes
Timberland Waterproof Boots
Cheap timberland boot On Sale
Mens Timberland Boots
Womens Timberland Boots
Cheap Timberland Boots
Timberland Winter Boots
Timberland Work Boots
Timberland Waterrproof Shoes
Timberland UK Boots