php category ul,li and span

[devianleong]

Hi, How can I add ul and li tag and add <span class="subDropdown plus"></span> before sub category <ul> called? ?
my database: ID,CatName,ParentID

This is the output I expected:

<ul>
                <li><a href="#">Car Accessories</a></li>      
                <li><a href="#">Clothing & Shoes</a>
                    <span class="subDropdown plus"></span>
                    <ul>                    
                      <li><a href="#">Shoes</a></li>
                      <li><a href="#">Sndals</a></li>
                      <li><a href="#">Dresses</a></li>
                      <li><a href="#">Jeans</a></li>                    
                    </ul>                  
                  </li>
                  <li><a href="#">Kids Toys</a></li>                
                  <li><a href="#">Digital Games & Softwares</a></li>
</ul>

Please help me. I'm new to php programming =(

[pritaeas]

What is the purpose of your span?

[devianleong]

it is just a small spacing between UL and LI

[pritaeas]

Why not use margin-bottom for li ul ?

[devianleong]

erm...the html template design is like this but I don't know how to loop in mysql while loop =(

[devianleong]

any solution to loop UL and LI? sub category contain like this

<li><a href="#">Clothing & Shoes</a>
                    <span class="subDropdown plus"></span>
                    <ul>                    
                      <li><a href="#">Shoes</a></li>
                      <li><a href="#">Sndals</a></li>
                      <li><a href="#">Dresses</a></li>
                      <li><a href="#">Jeans</a></li>                    
                    </ul>                  
                  </li>

Please help me =(

[pritaeas]

Closed, continued here.