Date help needed
Posted: Mon Sep 29, 2003 6:18 am
hi,
My requirement is data to be added to database depending on dates.Like,If the user wants to add data for the next 10 days,the data should be added with a corresponding column containing the next 10 days' dates.Then if he logs in tomorrow and wishes to add data for another 100 days,it should find the last date added and then add data with the next date starting from that date.Also I would want to display these dates to the user.So can you suggest which type to be used for database field and also the date functions(mysql as well as php) to be achieved.Any piece of code will be appreciated.
Thanks
My requirement is data to be added to database depending on dates.Like,If the user wants to add data for the next 10 days,the data should be added with a corresponding column containing the next 10 days' dates.Then if he logs in tomorrow and wishes to add data for another 100 days,it should find the last date added and then add data with the next date starting from that date.Also I would want to display these dates to the user.So can you suggest which type to be used for database field and also the date functions(mysql as well as php) to be achieved.Any piece of code will be appreciated.
Thanks