We are having a problem in php while grabbing and storing time in database, it is making 12 hours difference in it.
This is what we are using
**
$currentdate = date ( "Y-m-d h:i:s", mktime (date("h"),date("i"),date("s"),date("m"),date("d"),date("Y")));
//To predict out the exact date
now we are selecting from database
$rs=mysql_query("select * from table where ddate<'$currentdate'");
//It gives us all the records whose values are less than current time .
mysql_query("update table set ddate='".date ( "Y-m-d h:i:s", mktime (date("h"),date("i"),date("s"),date("m"),date("d")+1,date("Y")))."' where ....");
//Here we are updating the date to 1 more day means next time it will be picked up after 24 hours.
**
Now the problem that is occuring is it is picking up those records after 36 hours instead of 24.
When we had checked the $currentdate value and server time then the difference that comes out is
that $currentdate shows 06:47:25 the server time shows 18:47:25
which means some am/pm problem
06 is am 18 is pm
that is what is causing problems for us.
If anyone of you have a perfect solution for it just make a bid.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
any