note 41384 added to ref.mysqli

Here is a little sample to do fast hierarchical queries using new prepared statements // Root - lowest start element // Top - most top element // stack - array for storing info function tree_rise($root, &$stack, $top = 0) { $mysqli = mysqli_connect('localhost', 'root'); $top = (int)$top; $stmt = mysqli_prepare($mysqli, "SELECT id, pid, title FROM news.strg WHERE id = ? LIMIT 1"); mysqli_stmt_bind_param($stmt, "i", $root); mysqli_stmt_execute($stmt); mysqli_stmt_store_result($stmt); mysqli_bind_result($stmt, $id, $root, $title); while (mysqli_fetch($stmt)) { $stack[$id] = $title; if ($root != $top && !is_null($root)) { mysqli_stmt_execute($stmt); mysqli_stmt_store_result($stmt); } } return count($stack); } ---- Manual Page -- http://www.php.net/manual/en/ref.mysqli.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+41384 Delete -- http://master.php.net/manage/user-notes.php?action=delete+41384&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+41384&report=yes Search -- http://master.php.net/manage/user-notes.php