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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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/
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
