10.11.2016, 15:25
Hi i'm confused how to get date 1 - 6 days before, if now is sunday but i will get data from mysql database, how to get date for 1-6 days before.
And also, 1 month not always 31 days, if sunday is date 1. and month before is 31/30/29/28 how to get date before. i'm confused because i will trying to make profit system for business. in my opinion i will make a table with fill (businessid (int), value(int), date(varchar)), if player buy item from business it work like /buy > Player buying item > Insert data on table within businessid, value, date (now). but i confused how to get data from mysql database?, and how to get date before sunday.
example image from jogjagamers rp
Image
Thanks before.
And also, 1 month not always 31 days, if sunday is date 1. and month before is 31/30/29/28 how to get date before. i'm confused because i will trying to make profit system for business. in my opinion i will make a table with fill (businessid (int), value(int), date(varchar)), if player buy item from business it work like /buy > Player buying item > Insert data on table within businessid, value, date (now). but i confused how to get data from mysql database?, and how to get date before sunday.
example image from jogjagamers rp
Image
Thanks before.