Gentlemen, I'm not new with DBI by any means, but I am having the most terrible time finding what is wrong with this code.

These are the declarations of the queries. It goes to a MySQL database.

sub recursive_print_traversal {
        $parent = shift;                # the parent

        $addr = "select * from address_tbl where Subnet='$parent'";
        $subs = "select * from subnet_tbl where VLAN='$parent'";

        $addr_str = $dbh->prepare($addr);       # prepare address sele
+ct
        $subs_str = $dbh->prepare($subs);       # prepare subnet selec
+t


        $addr_rst = $addr_str->execute();       # execute address sele
+ct
        $subs_rst = $subs_str->execute();       # execute subnet selec
+t
[download]

Later I attempt to use the MySQL queries, like so.

        if ( $subs_rst == 0){
                print "<tr><td colspan=2 align=center>None.</td></tr>"
+;
                print "</table></td></tr>";
        } else {
                while ( @row = $subs_rst->fetchrow_array ) {
>>                      recursive_print_traversal($row[0]);
                }
        }
[download]

However, it yields the following error.

Can't call method "fetchrow_array" without a package or object referen
+ce at /var/www/cgi-bin/report.cgi line 127.
[download]

The line is question is mark with ">>" above.

amt

Janitored by davido: Restored deleted content. Please don't delete the contents of your nodes once the question has been resolved.