my own helper creating menu

[eluser]InsiteFX[/eluser]
1)For a helper like that you need to load it in your controller.
Your controller is the object.

If you need it across multiple controllers use a MY_Controller.

2) No you should not have html code in it unless you create.

3) A recursive function just calls itself.

Code:

function getChild($id)
        {
            $menu = "";
            $str = "";
            $s = "select id,title,parentid,link from ms_product where parentid = '$id' ";
            $res = $this->select_row($s);
            $menu .= '<div id="'.$id.'" style="display:none; position:absolute;">';
            $menu .= '<table border="1" cellspacing="0" cellpadding="0" style="border: 1px solid #FDCB55;  border-collapse:collapse;">';
            for ($i=0;$i<count($res);$i++)
            {
                $cnt_of_child = $this->recordCount("select id from ms_product where parentid = '".$res[$i][id]."' ");
                if ($cnt_of_child > 0)
                    $str = '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="arrow_white.gif">';
                else
                    $str = " ";


                $menu .= '<tr height="20"><td align="left"  class="aerial12">';
                $menu .= '<div style="padding-left:10px;padding-right:5px; width:125px;" >';


                $menu .= $res[$i][title].$str;
                $menu .= '</div>';
                $menu .= '</td><td align="left" valign="top">';
                $menu .= $this->getChild($res[$i][id]);
                $menu .= '</td></tr>';
            }
            $menu .= '</table>';
            $menu .= '</div>';
            return $menu;
        }

See how getChild calls itself.

InsiteFX