Re: need a new challenge

At 11:12 14-3-2003, you wrote:

Im looking for ideas for a 2 programming contests. What I need is a very basic challenge - that new php programmers can do, but involves them mixing there thinking/programming and creative abilities. I also need a challenge for professional programmers - something that involves lots of thought, tests their problem solving ability and code useage. haaaa! this is a great change to let others do my job :))))).

It's up to you in which category you place it: ------------------------------------- Metatable Suppose you've got one db table (meta-table) desribing the content of various other tables, for instance

        ID
      tablename
        fieldname
        fieldtype [integer|textarea|choicelist|link_to_other_table|....]
        default_value
        permissions
The easy part: make an interface so people can design their own db table, the description of every field goes into the metatable and the field is added to the datatable it refers to. With templates one can now quickly make show/edit/add/overview pages. I managed that.
Now I want to have choice lists that come from new tables. For instance: with this system they made a table
   person (gender, name, etc), now i want to add a choice list of institutions, where the institutions are in another table (institute name, address, etc).  Doing this directly is easier than doing it via this extra table.  Let them use a class?

----------------------------------- I'm pondering what other projects i can let them do ;) Chris