Reuse MySQL prepared statement

[Nathaniel Hall <newsgroups@xxxxxxxxxxxxxxxxx>]

I am trying to use a prepared MySQL statement after retrieving the
results from a previous query (it's for a multi-level menu).  The first
query works fine, but the second query does not.

I have tried using mysqli_stmt::reset and mysqli_stmt::close, but had no
luck with those either.  Lastly, the only time I receive error messages
is when I use mysqli_stmt::close.

The code I am currently using is:


[code]
$l1_parent = 0;
$retrieve_menu->bind_param("i", $l1_parent);
$retrieve_menu->execute();
$retrieve_menu->bind_result($menu_id, $menu_item, $menu_cmd);
$level1 = array();
while ($retrieve_menu->fetch()) {
     $level1_item = array();
     array_push($level1_item, $menu_id);
     array_push($level1_item, $menu_item);
     array_push($level1_item, $menu_cmd);
     array_push($level1, $level1_item);
}
$retrieve_menu->free_result();

$level1_counter = 0;
echo "<ul>";
for ($level1_counter = 0; count($level1) >= $level1_counter; $level1_counter++) {
     echo "<li><a href=\"https://myserver/?sid=$GENSID&uid=$GETUID&cmd="; . $level1[$level1_counter][2] . "\" class=\"" . $level1[$level1_counter][2] . "\">" .
$level1[$level1_counter][1] . "</a></li>";

     $l2_parent = $level1[$level1_counter][0];
     $retrieve_menu->bind_param("i", $l2_parent);
     $retrieve_menu->execute();
     $retrieve_menu->bind_result($menu_id, $menu_item, $menu_cmd);
     $level2 = array();
     while ($retrieve_menu->fetch()) {
          $level2_item = array();
          array_push($level2_item, $menu_id);
          array_push($level2_item, $menu_item);
          array_push($level2_item, $menu_cmd);
          array_push($level2, $level2_item);
     }
     $retrieve_menu->close();

     if (count($level2) > 0) {
          echo "<ul>";
          echo "<li><a href="/">$level2 " . $level1[$level1_counter][0] . "</a></li>";
          echo "</ul>";
     }
}
echo "</ul>";
[/code]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php