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 !!!
compare date
Moderator: General Moderators
- jayshields
- DevNet Resident
- Posts: 1912
- Joined: Mon Aug 22, 2005 12:11 pm
- Location: Leeds/Manchester, England
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
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
- jayshields
- DevNet Resident
- Posts: 1912
- Joined: Mon Aug 22, 2005 12:11 pm
- Location: Leeds/Manchester, England