school mailing system

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Chris Matchett
    #1

    school mailing system

    I am developing a bulk email system to send messages to parents of the
    children in the school I work at, using php and mysql. The database
    holding the parents' email addresses and what yeargroup their child is in.

    I would appreciate any input on the best method of tracking a pupil's
    yeargroup as they move up through the school. For example, I would like a
    field in each record to indicate what yeargroup they are currently a part
    of and when the next academic year comes around there wouldn't be any
    needs for an update.

    Any suggestions for a best approach?

    Regards,

    Chris


    Tags: None
    • Chris Matchett
      #2
      Re: school mailing system

      On Sun, 20 Feb 2005 13:34:12 +0000, Chris Matchett wrote:
      [color=blue]
      > I am developing a bulk email system to send messages to parents of the
      > children in the school I work at, using php and mysql. The database
      > holding the parents' email addresses and what yeargroup their child is in.
      >
      > I would appreciate any input on the best method of tracking a pupil's
      > yeargroup as they move up through the school. For example, I would like a
      > field in each record to indicate what yeargroup they are currently a part
      > of and when the next academic year comes around there wouldn't be any
      > needs for an update.
      >
      > Any suggestions for a best approach?
      >
      > Regards,
      >
      > Chris[/color]

      Apologies, should have cross-posted this message to alt.php.sql in
      first place (doing so now).

      Chris

        Comment

        • Al Kolff
          #3
          Re: school mailing system


          "Chris Matchett" <chrismatchett@ hotmail.com> wrote in message
          news:pan.2005.0 2.20.13.31.57.6 72370@hotmail.c om...[color=blue]
          > I am developing a bulk email system to send messages to parents of the
          > children in the school I work at, using php and mysql. The database
          > holding the parents' email addresses and what yeargroup their child is in.
          >
          > I would appreciate any input on the best method of tracking a pupil's
          > yeargroup as they move up through the school. For example, I would like a
          > field in each record to indicate what yeargroup they are currently a part
          > of and when the next academic year comes around there wouldn't be any
          > needs for an update.
          >
          > Any suggestions for a best approach?
          >
          > Regards,
          >
          > Chris
          >[/color]
          Chris,
          There is a lamp solution called ISchoolAd. More on topic is taht what we
          did was assign student numbers whwere the first to digits of the students
          number were his graduation year ie 2005 05 2006 06

          HTH
          Al


            Comment

            • John Hansknecht
              #4
              Re: school mailing system

              > On Sun, 20 Feb 2005 13:34:12 +0000, Chris Matchett wrote:[color=blue][color=green]
              >> I would appreciate any input on the best method of tracking a pupil's
              >> yeargroup as they move up through the school. For example, I would like a
              >> field in each record to indicate what yeargroup they are currently a part
              >> of and when the next academic year comes around there wouldn't be any
              >> needs for an update.[/color][/color]

              We have always assigned a 'graduation year' code. This will (hopefully
              <grin>) stay the same for a student during their time at your school. You
              can use it to identify same year students.
              --


              Thanks,

              John

                Comment

                Previous template Next
                Working...