pagegen Posted January 17, 2011 Share Posted January 17, 2011 Hi guys, I am trying to create a program which manages campaigns. each campaign has a start date and and end date. a user has to enter data releated to the campaign everyday example start date: 10-1-2011 end date: 17-1-2011 now all this information is stored in 2 tables 1st table is "campaigns" this stores the campaign name, start date and end date and 2nd table is "campaign_data" this table stored the data for each campaign and also date of when that data was entered my question is, if the user did not enter data on 11-1-2011 how will I know this, keeping in mind the month diffrence which can accur if the length of the campign was 2 month long? table: campaigns fields: id | campaign_name | start_date | end_date table: campaign_data fields: id | campaign_id | date | page Thank you Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted January 17, 2011 Share Posted January 17, 2011 How are the dates stored in the database? Are they in a DATE or DATETIME type field? Quote Link to comment Share on other sites More sharing options...
pagegen Posted January 17, 2011 Author Share Posted January 17, 2011 Hi mate Yes all dates are stored as "date" in the database Quote Link to comment Share on other sites More sharing options...
pagegen Posted January 19, 2011 Author Share Posted January 19, 2011 bump any advice guys Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted January 19, 2011 Share Posted January 19, 2011 Sorry, this got lost and buried in the forum. From what I gather, your goal is to check the entries to make sure that there has been an entry made every day? What is to happen if a day is skipped? Is it every day, or just weekdays? Quote Link to comment Share on other sites More sharing options...
pagegen Posted January 19, 2011 Author Share Posted January 19, 2011 Hi mate, we will need data to be entered everyday from start of campaign to end, and if there is missing data, just flag the issue, thank you Quote Link to comment Share on other sites More sharing options...
pagegen Posted January 20, 2011 Author Share Posted January 20, 2011 bump Quote Link to comment Share on other sites More sharing options...
pagegen Posted January 20, 2011 Author Share Posted January 20, 2011 any one? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.