schedlued

[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 date.

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?

should i have a daily and weekly column in my table where the date, time and message is stored

hope someone can help

[Dan_Bracuk]

I'd have a frequency table myself with a frequency_id in your existing table.

[RyanG24]

ok Dan thanks, thats sounds good

how does the frequency table work? ie what fields and how would i add to my code to use this

Many thanks

[Dan_Bracuk]

If it was my app, and it's not, the freqency table would have either two or three fields. It might be

frequency_id pk
minutes integer

or
frequency_id
every integer
time_unit text (week, minute, hour, etc)

in fact, the time_unit field might be an id field with a foreign key relationship to a time_unit table.

To the table that has your user information, add a frequency_id field.

[RyanG24]

ok 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