weekly repeat

[RyanG24]

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

[Dan_Bracuk]

frequency_id every time_until
1 1 day
2 1 week

join to your appointment table with the frequency_id

[RyanG24]

ok many thanks

so say i have in my appoint_table i have

Appt_ID = 12
date time = 12/02/2007 12:30:00
server time = 12/02/2007 12:30:00

then my freqency_table has

frequency_id = 12
every integer = ?
time_unit text = week

how would i change the code below to send out the email if Appt_ID = 12 needs to be sent out every week at the same time as the server time = 12/02/2007 12:30:00. if that makes sence?