MySQL DateTime

Arc

Hi. What is the proper way to insert a DateTime into MySQL? I know Date is done like $Today=Date("Y-m-d"); , but i'm not sure how to add the time.

Also, i am doing an auction sort of thing where i need to count down from this date from say 3 days down to 0. What is the best way to do that?

Thanks alot!😃

Arc

OK i figured out to insert it into the DB using $Now=Date("Y-m-d")." ".Time();.

Now i just need help figuring out to do a countdown based on that DateTime.

ir4z0r

i prefer using the UNIX/PHP-timestamp (seconds since 1.1.1970)

you get the current timestamp with time(), add 3 days from now
on would be: 3 (days) 24 (hours) 60 (min) * 60 (sec), which
you had to add to the number received by time()

if you store the new time in your mysqltable, you can easily get
the time difference each time the script is executed

(i'm quite bad at explaining, sorry about that :rolleyes: )

Arc

Hmm, i tried creating a field that is Timestamp and adding the value of Time() to it and it added 14 zeros. But all the other rows that i had not tried to add anything to were long numbers..235647698356412 for example. not sure what i'm doing wrong.

ir4z0r

MySQL is using a different timestamp than php, use "int" as
column type

Arc

OK now i'm more confused. I made the Field int(20) And i entered the value of Time() into the Field and it came back as 2003.

Here's the code

$Now=Time();
 $Sql="UPDATE tblReg SET DateAccepted='$Now' WHERE ID='$radID'";

I look in the DB and it says 2003
😕

ir4z0r

that's really strange, I'm using int(11) and my fields contain numbers
like 1048005308

have you echo'd $now before inserting?

Arc

I just tried it again and it worked. 😕 hehe thanks!

Arc

Ok i got another Sql problem here. I'm trying to pull all rows where Now is less than the DateAccepted + 3 Days but it keeps saying it's not a valid Sql Argument.

DateAccepted is the field thats holding the other Time() value

$Now=Time();
$Sql="SELECT * FROM tblReg WHERE ((OnlineID='$SESSION_UNAME' Or COlineID='$SESSION_UNAME') AND $Now < (DateAccepted + 86400))";

ir4z0r

try

"SELECT * FROM tblReg WHERE (((OnlineID='$SESSION_UNAME') Or (COlineID='$SESSION_UNAME')) AND ($Now < (DateAccepted + 86400)))"

there can never be to much brackets (I guess)

Arc

Nope🙁 i've tried every combo of bracets i can think of. I've made sure al the field names are spelled correctly too. I have no idea why it's not working.

ir4z0r

then post the exact error here and the latest version of your query

Arc

Hi. I just figured out the problem. One of the DateAccepted rows in my DB had a NULL value, so aparenlty it couldnt do math with a NULL value and was giving the error....ugh what a huge waste of time haha.

Thanks for the help!😃