Change snippet to use CURDATE

Posted on 16th Feb 2014 07:03 pm by admin

I am using time() in the snippet below, I would like to use CURDATE() and have the database setup for date. My problem is, I am not sure how to change the PHP coding, I keep getting errors just adding CURDATE() where time() is. Any help would be greatly appreciated...


$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()."')");

Your Answer:

Login to answer

Other forums

Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.

I am able to display data

How to make a input/output field with multiple lines
Hello.
I put a input/output field on the screen but I could not change height of it. I need to

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

Any decent php formatter/beautifier/pretty printer?
Any decent php formatter/beautifier/pretty printer class/function?

I found the following whil

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

$_POST variable un-useable
I'm trying to use a $_POST variable in a mysql update statement but i can't use it for some unknown

simple php table loop
Hi all,

I've the following code

<?php // Create category options

chat
hello i'm amir i need a chat source code in asp.net 2.0 without Ajax. anybody can help me?

mail()
Hi all. I have a problem with emails. I am trying to set up a mail system where customers can subscr

Just a white page
Okay so, my website, when I click SignUp on it it takes me to /join.php but its a complete white pag