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 Link to comment https://forums.phpfreaks.com/topic/224725-dates/ 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? Link to comment https://forums.phpfreaks.com/topic/224725-dates/#findComment-1160737 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 Link to comment https://forums.phpfreaks.com/topic/224725-dates/#findComment-1160742 Share on other sites More sharing options...
pagegen Posted January 19, 2011 Author Share Posted January 19, 2011 bump any advice guys Link to comment https://forums.phpfreaks.com/topic/224725-dates/#findComment-1161843 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? Link to comment https://forums.phpfreaks.com/topic/224725-dates/#findComment-1161950 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 Link to comment https://forums.phpfreaks.com/topic/224725-dates/#findComment-1161965 Share on other sites More sharing options...
pagegen Posted January 20, 2011 Author Share Posted January 20, 2011 bump Link to comment https://forums.phpfreaks.com/topic/224725-dates/#findComment-1162411 Share on other sites More sharing options...
pagegen Posted January 20, 2011 Author Share Posted January 20, 2011 any one? Link to comment https://forums.phpfreaks.com/topic/224725-dates/#findComment-1162506 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.