schedlued

Forum|Forum|19 years ago
February 26, 2007
2 replies
380 views

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

Advanced techniques

This topic has been closed for replies.

D

Dan_Bracuk

Inspiring

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.

R

RyanG24Author

Known Participant

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

D

Dan_Bracuk

Inspiring

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