I have a table like this..... 
Table :- test
category_id   | category_name          | main_category | 
+-------------+------------------------+---------------+
|           1 | One                    |             0 | 
|           2 | Two                    |             0 | 
|           3 | Three                  |             0 | 
|           4 | Four                   |             0 | 
|           5 | Six                    |             1 | 
|           6 | Seven                  |             1 | 
|           7 | Eight                  |             1 | 
|           8 | Twelve                 |             2 | 
|           9 | Thirteen               |             2 | 
|          10 | Nine                   |             5 | 
|          11 | Five                   |             0 | 
|          12 | Ten                    |            10 | 
|          13 | Eleven                 |             5 |

[download]
Using this table i would like to maintain a structure like this (in drop down menu). 
One    
  Six
    Nine
      Ten
    Eleven
  Seven
  Eight
     
Two 
  Twelve
  Thirteen

Three
Four 
Five

[download]
I am using this query to solve this problem... 
 Query 1 :- Select category_id from test where main_category='0';
 Query 2 :- Select category_id from test where main_category=(result f
+rom query 1)

[download]
Could you pls help me solve this problem?
Thanks

20030319 Edit by Corion : Added formatting, retitled node

In reply to Using SQL to create menu entries (was: Could u pls help me to solve....) by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.