Re: [PHP] Reuse MySQL prepared statement

2008-09-29 Thread Richard Heyes
> I would recommend using using a preorder tree traversal for storing > the data. It is a little different at first, but once you get the > idea it is pretty slick to work with. The main advantage is to build > the tree structure you only need one query as opposed to a recursive > algorithm. Thi

Re: [PHP] Reuse MySQL prepared statement

2008-09-29 Thread Nathaniel Hall
Eric Butera wrote: > On Mon, Sep 29, 2008 at 11:21 AM, Richard Heyes <[EMAIL PROTECTED]> wrote: >>> Use a tree structure (I assume it's a tree type menu that has already >>> been written and save yourself the hassle. The PEAR HTML_TreeMenu code >>> can Create a tree structure from a Tree object (my

Re: [PHP] Reuse MySQL prepared statement

2008-09-29 Thread Eric Butera
On Mon, Sep 29, 2008 at 11:21 AM, Richard Heyes <[EMAIL PROTECTED]> wrote: >> Use a tree structure (I assume it's a tree type menu that has already >> been written and save yourself the hassle. The PEAR HTML_TreeMenu code >> can Create a tree structure from a Tree object (my own tree class at >> ph

Re: [PHP] Reuse MySQL prepared statement

2008-09-29 Thread Richard Heyes
> Use a tree structure (I assume it's a tree type menu that has already > been written and save yourself the hassle. The PEAR HTML_TreeMenu code > can Create a tree structure from a Tree object (my own tree class at > phpguru.org). Sorry, forgot to mention that said Tree object can create a tree s

Re: [PHP] Reuse MySQL prepared statement

2008-09-29 Thread Richard Heyes
> 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. Use a tree structure (I assume it's a tree type menu that has already been written and save yourself the