core-bundle/src/Resources/contao/library/Contao/Database.php
public function getParentRecords($intId, $strTable)
	{
		$arrReturn = array();

		// Currently supports a nesting-level of 10
		$objPages = $this->prepare("SELECT id, @pid:=pid FROM $strTable WHERE id=?" . str_repeat(" UNION SELECT id, @pid:=pid FROM $strTable WHERE id=@pid", 9))
						 ->execute($intId);

		while ($objPages->next())
		{
			$arrReturn[] = $objPages->id;
		}

		return $arrReturn;
	}
public function getParentRecords($intId, $strTable)
	{
		$arrReturn = array();

		// Currently supports a nesting-level of 10
		$objPages = $this->prepare("SELECT id, @pid:=pid FROM $strTable WHERE id=?" . str_repeat(" UNION SELECT id, @pid:=pid FROM $strTable WHERE id=@pid", 9))
						 ->execute($intId);

		while ($objPages->next())
		{
			$arrReturn[] = $objPages->id;
		}

		return $arrReturn;
	}
public function getParentRecords ( $ intId , $ strTable ) { $ arrReturn = array ( ) ; // Currently supports a nesting-level of 10 $ objPages = $ this -> prepare ( "SELECT id, @pid:=pid FROM $strTable WHERE id=?" . str_repeat ( " UNION SELECT id, @pid:=pid FROM $strTable WHERE id=@pid" , 9 ) ) -> execute ( $ intId ) ; while ( $ objPages -> next ( ) ) { $ arrReturn [ ] = $ objPages -> id ; } return $ arrReturn ; }
Return the IDs of all parent records of a particular record

@param integer $intId    The ID of the record
@param string  $strTable The table name

@return array An array of parent record IDs
Return the IDs of all parent records of a particular record