Page 1 of 1
compare date
Posted: Mon Jan 08, 2007 5:07 pm
by hrubos
Who would mind suggesting for me .
Now I don't know how the way to do that :
Everymonths we have to pay a house_bill, and if over the new month u have to will a housle bill and plus more 50usd.So what to solve it
Thank you !!!
Posted: Mon Jan 08, 2007 5:29 pm
by jayshields
You need to use better English than that so we know exactly what you're getting at. Also, if you could post your own attempt at what you are trying to achieve we will give you some pointers.
Posted: Mon Jan 08, 2007 7:39 pm
by hrubos
So I need the solution to make system understand that : when person still paid house_bill for a old month and now it's new month, so his bill now which he has to pay, have been plus 5 usd.
So how is condition with function date() .
Example that : I have a table
(today : 09/01/2007)
Name | Amount | Date |
Kevin | 500 | 2007-01-09 | pay
so if he don't paid the bill to 01/02/2007 , I will output that table :
Name | Amount | Date |
Kevin | 550 | 2007-01-09 | pay
Posted: Mon Jan 08, 2007 7:50 pm
by jayshields
You will probably need to use a cron job to automatically check the dates in the table every day and if any of the dates are one month earlier than todays date add 50 to the amount column associated with that date.