Hi i have a scheduled email system, where a user selects a
time and date, which gets converted to my server time and date, and
then gets put into my database with the email message,
the server then sends out emails if the time and date is less
than the current server datetime.
what i need to do now is add a daily and weekly tick box to
the form, but i am not sure how i should use my database to do
this?
so at the min i have a table called appoint_table which has
Appt_ID (unique)
date time (message was created)
server time (if this is less than the current server time the
email gets sent)
so then if i have a table called freqency_table with
frequency_id
every integer
time_unit text (week, minute, hour, etc)
what would every integer be?
and how would i link this to my appoint_table
many thanks for all your help