Help switching to DATE format

[codeboy89]

I am currently using time() in the created_at entries, I would like to use CURDATE, but cannot get it to work. can anyone please fix this snippet.

 

 

        $update = mysql_query("UPDATE comments SET comment='".$comment."',created_at='".time()."' WHERE user_id=".$_SESSION['logged_id']);

 

      } else {

 

        $insert = mysql_query("INSERT INTO comments(`id`,`user_id`,`comment`,`created_at`) VALUES(0,".$_SESSION['logged_id'].",'".$comment."','".time()."')");

[codeboy89]

i have the database setup for date, i am just not sure what to do for the code in this snippet, i keep getting errors using CURDATE()

[l0ve2hat3]

on your table structure just change the `created_at` attribute to on update current time stamp. and it will automatically do it for you

[codeboy89]

i changed it to DATETIME and it just shows up as 0000-00-00 00:00:00

[l0ve2hat3]

did you change the attribute to current timestamp?

[codeboy89]

i have changed the attribute to everything in phpmyadmin and get nothing but zeros, so im sure i need change from time() to curdate() but i get errors, i am not sure how to change it correctly in the snippet

[l0ve2hat3]

         $update = mysql_query("UPDATE comments SET comment='".$comment."' WHERE user_id=".$_SESSION['logged_id']);

      } else {

         $insert = mysql_query("INSERT INTO comments(`id`,`user_id`,`comment`) VALUES(0,".$_SESSION['logged_id'].",'".$comment."')");

 

 

[codeboy89]

         $update = mysql_query("UPDATE comments SET comment='".$comment."' WHERE user_id=".$_SESSION['logged_id']);

      } else {

         $insert = mysql_query("INSERT INTO comments(`id`,`user_id`,`comment`) VALUES(0,".$_SESSION['logged_id'].",'".$comment."')");

 

how will that work?

[l0ve2hat3]

did you try it? if you have the attribute "on update current_timestamp" mysql will automatically update the field with the current time stamp