Mysql Auto Table Creation By Date

Discussion in 'Web Design and Development' started by SChaput, Feb 13, 2010.

  1. SChaput macrumors regular

    Joined:
    Jul 2, 2008
    Location:
    United States
    #1
    Good Evening All,

    I am going to try and describe the issue i am having to the best of my ability, if you have any questions, please let me know.

    I am trying to write a website for a committee that reviews individual parts of a company and rates them, to see if they are up to standards, every five years. They review ≈ 7 departments every year.

    I have a database of all 34 departments they review in a 5 year period with a column for "baseline review". So some departments were first reviewed in 2008, some in 2009, some in 2010 etc. I need to find some way to, at the beginning of every year create a record in my table for each of the departments being reviewed in that current year.

    Any help is greatly appreciated.

    Thanks!
     
  2. angelwatt Moderator emeritus

    angelwatt

    Joined:
    Aug 16, 2005
    Location:
    USA
    #2
    Ca you describe the current database schema? I'm not following the problem currently.
     

Share This Page