Results 1 to 3 of 3
  1. #1

    Email Notification Script Needed


    I have a client that runs a student property management company. My client wants to automated Notice Of Entry notifications.

    Currently procedure:

    1. Staff creates scheduled viewing of unit.
    2. Send out mass emails to all units were there is scheduled viewing.

    I would like to automate it this way.

    1. I can set up a cron to run on a hourly basis
    2. PHP page will execute and check if there are any new scheduled viewings (where viewing_date != '0000-00-00 00:00:00' )

    3. If there are, it will send out a personalized email - get values from table.
    4. Send Confirmation email to staff email address.


    - Tenants from 100 Eighth Avenue, Unit:5 were notified.
    - Tenants from 100 Eighth Avebue, Unit:6 were notified.
    5. Log the notification to another mysql table for auditting purposes. (Date, Address, Unit)
    6. Update field scheduled viewings to '0000-00-00 00:00:00',
    so the next time the cron runs, it will not send out duplicate notification emails.

    I can write the SQL for the script. I just need the frame work. I know how to do in PL/SQL but I am not a php developer.

    Thank You



  2. #2
    Complete system (SQL and PHP) with specs as above: $75

    Contact me via PM or chris [at]

  3. #3
    check out we have some good programmers there who can help you with what you want to do.

    we set it up in such away that people will post a a bid on what your project is all about and you decide who you want to go with and still maintain your privacy...

    also you are exposed to many more talents,

    hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts