Re: Date Formatting/Reading

Got a question, I just noticed your signature, 'earn up to $10 per order selling our PHP Scripts'. Are you paying us to help you out? =) Just messing with ya. Anyway, you'd probably want to use a 'DATE' field. For checking the passing of a month, the easiest way would be to use the getdate() function. You can check the numerical value of the month and day to see if a month has passed. The only thing you might want to be careful is if someone signs up on the 29-31, because February only has 28 days so the days (29-31) would never match up. And of course the same goes for months with 30 days and people who sign up on the 31st. Unfortunately, I do not know of a way to do 'math' with dates to get the 30 day difference. I'm sure that with a little effort, you could write something that will do it. ----EXAMPLE--- $today = getdate(); $month = $today['month']; $mday = $today['mday']; ///get date from database if ((($month - $dbmonth) == 1) && ($mday == $dbday)) { ///time to renew ///also take into account the transition from December to January, so $month-$dbmonth == -12 } -----END----- Best regards, Jeremy Reed "Phpgalaxy.Com" <archive@php.la> wrote in message news:3C188281.DD708BD1@php.la... > Hi! =) > > I'm doing a website that will be using a pay-per-month membership > program. There's a field for 'lastpaid' that holds the date the last > paid (sorry to state the obvious). My questions are these: > 1) What would be the best way to format it so PHP can see if it's been > 30 days since it was last paid? > 2) What line of code would be used to check? > 3) Would I set the field type to DATE, DATETIME, TIMESTAMP or soemthing > else? > > Any help you can give would be much appreciated! I woulda taken the time > to study it more in-depth but I'm trying to get as much done on this in > 5 hours as I can. =) > > ~ Tim > > -- > From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts > and Software on your Site. http://www.phpgalaxy.com/aff/ > > Also, get a fast free POP3 email account, you @php.la at > http://www.phpgalaxy.com/search/ > >