 |  |  |  |  |  |  |  |
Adding x amount of days to a specific date?
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: May 2005
Posts: 232
Reputation: 
Solved Threads: 0
Posting Whiz in Training
I have looked everywhere, I've figured out how to add x amount of days to the current date, or take away x amount of days from the current date. But let's say I have a date stored in my database as "0000-00-00", that is not the current date. How can I take that date and add a certain number of days to it?
I'm using php with a mysql database. I did find one sql command that works when I run it in the sql command line, but not on php. It's
Of course in the command line I put an actual date in the $mydate portion. But in php, it looks like this:
$mydate is just a date in the form 0000-00-00 pulled from somewhere else in my database. But it keeps spitting out "Resource id #8."
What's a simple way to add some days to a given date?
I'm using php with a mysql database. I did find one sql command that works when I run it in the sql command line, but not on php. It's
SELECT DATE_ADD('$mydate', INTERVAL 14 DAY)Of course in the command line I put an actual date in the $mydate portion. But in php, it looks like this:
$next_date=mysql_query("SELECT DATE_ADD('$mydate', INTERVAL 14 DAY)");$mydate is just a date in the form 0000-00-00 pulled from somewhere else in my database. But it keeps spitting out "Resource id #8."
What's a simple way to add some days to a given date?
•
•
Join Date: Aug 2005
Posts: 5,273
Reputation: 
Solved Threads: 378
>0000-00-00
This is meaningless. At least say something like: yyyy-mm-dd
This is meaningless. At least say something like: yyyy-mm-dd
*Voted best profile in the world*
•
•
Join Date: May 2005
Posts: 232
Reputation:
Solved Threads: 0
Posting Whiz in Training
Not exactly meaningless, that's the format you have to put in the mysql table to tell it what format you want. Ok, my date format is yyyy-mm-dd.
>$mydate is just a date in the form 0000-00-00 pulled from somewhere else in my database. But it keeps spitting out "Resource id #8."
That means $mydate is not what you expect. It's probably the result of mysql_query(). Use mysql_fetch_array() or mysql_result() to get the value.
That means $mydate is not what you expect. It's probably the result of mysql_query(). Use mysql_fetch_array() or mysql_result() to get the value.
•
•
Join Date: Sep 2007
Posts: 271
Reputation: 
Solved Threads: 16
Posting Whiz in Training
remember the code that i gave to increase numbers by one... change to datediff and it will work 
$AddOneDay = " mycolumn BETWEEN date_format(Now() + INTERVAL 1 DAY,'%e/%c/%Y - %H:%i:%s') AND date_format(Now(),'%e/%c/%Y - %H:%i:%s') ";
how many days you want, change that 1 to any number...
$AddOneDay = " mycolumn BETWEEN date_format(Now() + INTERVAL 1 DAY,'%e/%c/%Y - %H:%i:%s') AND date_format(Now(),'%e/%c/%Y - %H:%i:%s') ";
how many days you want, change that 1 to any number...
Last edited by fatihpiristine; Nov 2nd, 2007 at 1:00 pm.
Do a favour, leave me alone
•
•
•
•
Originally Posted by nathanpacker 
I have looked everywhere, I've figured out how to add x amount of days to the current date, or take away x amount of days from the current date. But let's say I have a date stored in my database as "0000-00-00", that is not the current date. How can I take that date and add a certain number of days to it?
I'm using php with a mysql database. I did find one sql command that works when I run it in the sql command line, but not on php. It'sSELECT DATE_ADD('$mydate', INTERVAL 14 DAY)
Of course in the command line I put an actual date in the $mydate portion. But in php, it looks like this:$next_date=mysql_query("SELECT DATE_ADD('$mydate', INTERVAL 14 DAY)");
$mydate is just a date in the form 0000-00-00 pulled from somewhere else in my database. But it keeps spitting out "Resource id #8."
What's a simple way to add some days to a given date?
php Syntax (Toggle Plain Text)
•
•
Join Date: May 2005
Posts: 232
Reputation:
Solved Threads: 0
Posting Whiz in Training
Thanks guys, that got it working right.
php Syntax (Toggle Plain Text)
The above is a purely php way of finding the number of days from a certain date. In the date, notice I put m and d and NOT mm and dd. For mktime use 8, not 08 or you will get the wrong date. This is my first post on daniweb, hope everything views OK.
|
Similar Threads
- array structs, size swap functions, the amount of days between to dates (C++)
- Date (Java)
- Function Question! (Computer Science)
- help calculating days (C++)
- Countdown to a date (Visual Basic 4 / 5 / 6)
- Logic to Convert Days From 1800 to a Date (Month, Day, Year) (C++)
- How to erase Date Last Accessed Info (Windows NT / 2000 / XP)
Other Threads in the PHP Forum
- Previous Thread: problem comparing strings
- Next Thread: How to hide .php extension
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess access ajax apache api array autosuggest beginner binary broken cakephp checkbox class cms code cron curl database date directory display download dynamic echo email emptydisplayvalue eregi error execute explodefunction file files folder form forms function functions google hack href htaccess html image include insert integration ip java javascript joomla keywords library limit link login loop mail menu mlm mod_rewrite multiple mysql oop parse paypal pdf php problem query radio random recursion regex remote script search searchbox server sessions sms soap source space sql structure syntax system table tutorial update upload url validation validator variable video web website xml youtube
