setting "page priviledges" info to multiple pages in database at once

[eaglesoft]

I have a database table called "pages".. There are different fields in those, most important for this issue are:

page_id
page_parent_id
page_priviledges

Now I already have multiple pages with multiple subpages. Now Id need a script that would work like this:

Let's say we have three pages. Page1, Page2 and Page3

Page1 is the frontpage
Page1 is parent of Page2
Page2 is parent of Page3

I set the page_priviledges to "1" for Page1. Those would need to save also to Page2 and Page3 since they're "children" and "grand-children" of Page1. It would save a lot of work for setting each page a priviledge of it's own.. And I think this is somehow possible..

Any help? does anyone have a similar kind of script that would need just a little modification to fill my needs?

Thanx in advance

[devinemke]

what exactly is the "page_priviledges" field? a boolean?
anyway, perhaps you could have the page_priviledges field default to NULL and then have a function that grabs the current record's row and recursively walks up the chain looking for a non-NULL page_priviledge. here is an an untested example (assuming mySQL) :

function get_priviledge($page_id)
{
	$result = mysql_query('SELECT page_parent_id, page_priviledges FROM pages WHERE page_id = ' . $page_id);
	$row = mysql_fetch_assoc($result);
	if ($row['page_priviledges']) {$page_priviledges = $row['page_priviledges'];}
	else
	{
		$page_parent_id = $row['page_parent_id'];
		unset($row);
		$page_priviledges = false;

	while (!$page_priviledges)
	{
		$result = mysql_query('SELECT page_parent_id, page_priviledges FROM pages WHERE page_id = ' . $page_parent_id);
		$row = mysql_fetch_assoc($result);
		if ($row['page_priviledges'])
		{

			$page_priviledges = $row['page_priviledges'];
		}
		else
		{
			$page_parent_id = $row['page_parent_id'];
		}
	}
}

return $page_priviledges;
}