Select Code to Download

TABLE_STUFF
~~~~~~~~~~~~~~~~~~~~
ID (pk)
name
parent_ID

TABLE_STUFF
~~~~~~~~~~~~~~~~~~~~
...
rght
depth
lineage

sub rebuild_tree
{
...
    $sth2->execute($left, $right, $dir_ID);
    return $right + 1;
}

use vars qw($sth);
....

# And then in the function
$sth || = $dbh->prepare($sql);

DBD::mysql::st fetchrow_arrayref failed: fetch() without execute()