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

INSERT data problem!
After having an string with apostrophes ', double quotes " or any other special characters, suc

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

PHP Game
hy i was wondering what's the best method in order to make some automatic updates in a php game
<

Not showing whole name with mail () script
I sent up a simple mail form with the PHP mail() script. One problem is when it sends an email with

MySQL issue
I am taking sentences through a form on page. Then checking some condition and trying to insert them

header redirect problems? please help
Ok i am making a site that generates youtube thumbnails and i am generating an image that displays 1

utf8_general_ci error ??
I have all kinds of data to be inserted in database table

//I am getting this error

Yo

fopen() security
As i understood the usage of fopen() for it to function correctly the Dir you write to has to be rw

how to get sn motherboard
Hello.
I want to get serial number motherboard, cpu and else hardware.
Can You show me sam

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s