add anchors and spans

[hamza]

i have a function which is recursively creating list menu

i only want to include classes , span tag kindly see the output

schema is attached

mysql_connect('localhost','root','root');mysql_select_db('sre');
  global $menu_array; 
  //running query
  $result = mysql_query("SELECT * FROM `tblcatagory`");  
//fetch rows to show like tree
while ( $row = mysql_fetch_assoc($result) )
{
        $menu_array[$row['cat_id']] = array('Categoryid'=> $row['cat_id'],'name' => $row['cat_name'],'parent' => $row['parent']);	
}
//recursive function that prints categories as a nested html unorderd list
function generate_menu($parent)
{
	$has_childs = false;
        //this prevents printing 'ul' if we don't have subcategories for this category      	
	 //make array global
	 global $menu_array; 
	//use global array variable instead of a local variable to lower stack memory requierment
    foreach($menu_array as $key => $value)        {
	        if ($value['parent'] == $parent) 
                {   //if this is the first child print '<ul>'             if ($has_childs === false)                        {
                                //don't print '<ul>' multiple times                                                             $has_childs = true;                                echo '<ul id="red" class="treevi ew-red treeview">';   }   echo '<li>  <span> ' . $value['name'].'</span>';
                        generate_menu($key);  //call function again to generate nested list for subcategories belonging to this category
                        echo '</li>';               }      }      if ($has_childs === true) echo '</ul>';} echo generate_menu(0);

i need output like this ..........

<UL id="red" class="treeview-red treeview">
<LI><A href="http://www.aeesolar.com/catalog/index.html" id="ovwLink">Overview</A></LI>
<LI class="expandable"><DIV class="hitarea  expandable-hitarea"></DIV><SPAN>Pre-Configured Systems</SPAN>
	<UL style="display: none; ">
		<LI><A href="./AEE Solar grid-tie PV power systems, grid-tie solar power systems_files/AEE Solar grid-tie PV power systems, grid-tie solar power systems.htm" class="selected">Grid-tie</A></LI>
		<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_PC_GTBB.htm">Grid-tie with battery backup</A></LI>
		<LI class="last"><A href="http://www.aeesolar.com/catalog/products/H_ASW_PC_RP.htm">Remote power</A></LI>
	</UL>
</LI>
<LI class="expandable"><DIV class="hitarea expandable-hitarea"></DIV><SPAN class="">Solar Modules</SPAN>
	<UL style="display: none; ">
		<LI class="expandable"><DIV class="hitarea expandable-hitarea "></DIV><SPAN>PV modules</SPAN>
			<UL style="display: none; ">
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PVM_EGS.htm">Evegreen</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PVM_REC.htm">REC</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PVM_MIT.htm">Mitsubishi</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PVM_SWD.htm">SolarWorld</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PVM_SCT.htm">SCHOTT Solar</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PVM_KYO.htm">Kyocera</A></LI>
				<LI class="last"><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PVM_AEE.htm">AEE Solar</A></LI>
			</UL>
		</LI>
		<LI class="expandable lastExpandable"><DIV class="hitarea expandable-hitarea lastExpandable-hitarea "></DIV><SPAN>Portable PV modules</SPAN>
			<UL style="display: none; ">
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PPVM_GSE.htm">Global Solar</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PPVM_PFM_RU.htm">PowerFilm roll-up</A></LI>
				<LI class="last"><A href="http://www.aeesolar.com/catalog/products/H_ASW_SM_PPVM_PFM_UF.htm">PowerFilm ultra-flexible</A></LI>
			</UL>
		</LI>
	</UL>
</LI>
<LI class="collapsable"><DIV class="hitarea  collapsable-hitarea"></DIV><SPAN class="">Mounting Structures</SPAN>
	<UL style="display: block; ">
		<LI class="expandable"><DIV class="hitarea expandable-hitarea "></DIV><SPAN>SnapNrack</SPAN>
			<UL style="display: none; ">
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_SNR_UK.htm">Universal kits</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_SNR_SR.htm">Standard rail sets</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_SNR_RA.htm">Roof attachment pieces</A></LI>
				<LI class="last"><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_SNR_GM.htm">Ground mount</A></LI>
			</UL>
		</LI>
		<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_QMT.htm">Quick Mount PV - waterproof flashing</A></LI>
		<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_CRT.htm">CreoTecc tile - roof hooks</A></LI>
		<LI class="expandable"><DIV class="hitarea expandable-hitarea "></DIV><SPAN>Unirac</SPAN>
			<UL style="display: none; ">
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_UNR_CMS.htm">CLICKSYS Mounting system</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_UNR_2R.htm">2-rail kits</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_UNR_4R.htm">4-rail kits</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_UNR_RB.htm">Bulk rail bundles</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_UNR_LF.htm">L-feet</A></LI>
				<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_UNR_SBP.htm">Splice bars and plates</A></LI>
				<LI class="expandable"><DIV class="hitarea expandable-hitarea "></DIV><SPAN>Top mounting clamp sets</SPAN>
					<UL style="display: none; ">
						<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_UNR_CS_A.htm">Clear anodized</A></LI>
						<LI><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_UNR_CS_B.htm">Dark bronze</A></LI>
						<LI class="last"><A href="http://www.aeesolar.com/catalog/products/H_ASW_MS_UNR_CS_LFM.htm">Lipped frame model</A></LI>
					</UL>
				</LI>

 

 

[attachment deleted by admin]