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.

$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

Best regards,

Jeremy Reed

"Phpgalaxy.Com" <[EMAIL PROTECTED]> wrote in message
> 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, earn up to $10 per order selling our PHP Scripts
> and Software on your Site.
> Also, get a fast free POP3 email account, you at

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to