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

Is this Safe or Unsafe?
Hi i made a few pages with lots of peoples help now i just want to know if they are safe or not can

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

elseif help!
OK so I'm new to the site, as well as PHP altogether (Trying my hand at managing an online RPG) and

Why does my php page download images over and over
Can anybody please explain to me why my php page keeps downloading the images and other items every

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

Chat Box in PHP
I was thinking in doing a Chat Box in PHP. For that I would use a form with two fields, Nick and Mes

PHP submit form script causing blank page
Im trying to submit a form using this script, however nothing shows up on the page, does anyone know

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

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev

in php, link returns to the line
When I add a link in a php page, the link word returns to the line (as a
would do)

Examp