I am just wondering if someone could tell me the best way to code this project I'm working on. I seek ur wisdom ;o)

I am creating a new site for a friend of mine, who owns a web hosting business. He has multiple groups, and each group has multiple hosting plans.

What would be the best way to make this dynamic? I am creating the system using a MySQL database. I created one table for groups. He can add, from the back end interface I made, new groups, which he can assign a group id(number), and a group name.

I created the hosting Plans table, which is ONLY for the plan NAME, and assigned group id(number).

This is where I am confused.

How can I get it where all the features would be automatically added to a comparison table, like this:
-----------------------------------------------------------
FEATURES|plan1 name | plan2 name | plan3 name | plan4 name |
-----------------------------------------------------------
feature1 name | Yes | No | Yes | yes|
-----------------------------------------------------------
feature2 name | Yes | Yes | Yes | Yes |
-----------------------------------------------------------

[download]
and so forth. Basically, just a regular table with the plan names at the top, and the feature names on the left side, with the details under that plan name, like yes, no or how many it might include, including the possibility of unlimited.

I have been racking my brain trying to find a simple, and managable way to do this.

I would really love it if someone had an idea that I could use.

Thank you very much!
Xav

In reply to Creation Suggestion needed... please by ukndoit

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.