Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 2469 | Replies: 8
 |
•
•
Join Date: May 2005
Posts: 230
Reputation: 
Rep Power: 4
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: 4,832
Reputation:
Rep Power: 17
Solved Threads: 324
>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
... the hat of 'is this a cat in a hat?'
•
•
Join Date: May 2005
Posts: 230
Reputation:
Rep Power: 4
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.
•
•
Join Date: Aug 2006
Posts: 138
Reputation:
Rep Power: 3
Solved Threads: 2
Junior Poster
>$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
Location: Budapest
Posts: 252
Reputation: 
Rep Power: 0
Solved Threads: 14
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
•
•
Join Date: Aug 2007
Location: Cavite,Philippines
Posts: 508
Reputation:
Rep Power: 3
Solved Threads: 68
Posting Pro
•
•
•
•
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?
you must use mysql_result to get the date.
php Syntax (Toggle Plain Text)
"death is the cure of all diseases..."
http://ryantetek.wordpress.com
http://ryantetek.wordpress.com
•
•
Join Date: May 2005
Posts: 230
Reputation:
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
Thanks guys, that got it working right.
•
•
Join Date: Nov 2007
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
