PHP Database::getResultsV Examples

Example #1

File: class.node.php Project: umonkey/molinos-cms

 /**
  * Возвращает идентификаторы родителей указанной ноды.
  */
 public static function getNodeParentIds(Database $db, $id)
 {
     $sql = "SELECT `parent`.`id` as `id` " . "FROM `node` AS `self`, `node` AS `parent` " . "WHERE `self`.`left` BETWEEN `parent`.`left` " . "AND `parent`.`right` AND `self`.`id` = ? " . "ORDER BY `parent`.`left`";
     return $db->getResultsV("id", $sql, array($id));
 }