Breadcrumb menu

[Hylian]

Alright...basically what I want to do is store all my content in a table called "content" (lol) and define if it's a category or a page. If it's a category, it will just act as a page and display all the pages within the category with the description of what each page is about and a link to it...

Well...I want to create a breadcrumb menu for the top that will look something like this:

If it's on a page:
Main Site » Category » Page

If It's a category:
Main Site* » Category

yet I also want to have a value in the database such as "parentcategory" so as long as it has a parent category set, it will continue to do the "Name »" thing.

For Example:
Main Site » Category » Sub Category » Child of "Sub Category" » Page

*it's a link to the page

Where lets say "Child of 'Sub Category'" " has it's parent category as "Sub Category"

How would i do this with a function that took variables like:
makeBreadCrumn($page);

and a linking system like:
www.mysite.com/index.php?page=whatever

I'm thinking I do it as a while loop, yet I'm not really sure...could someone help me out?

[Hylian]

LOL...I always seem to solve my own problems...

here's how to do it:

function makebreadcrumb($page){
	global $db, $n;

$page_info = $db->query_first("SELECT parentcat FROM hh_content WHERE refference = '$page'");
$result['parentcat'] = $page_info['parentcat'];
$out = "";
while($result['parentcat']!="0"){
	$result = $db->query_first("SELECT parentcat,title FROM hh_content WHERE id = '$result[parentcat]'");	
	$out = " <a href=\"#\">".$result['title']."</a> &raquo;".$out;	
}
return $out;
}

basically, before you start the while loop, you set the returned parent category as the same value in while loop...in this case...the $result array...