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

Add trigger to UpdatePanel programmatically
Hi,I'm working on a website which uses AJAX and Masterpages. What I have is an AJAX UpdatePanel whi

A little help in c#
i am doing a simple paint program using c# i want to draw with the mouse so i wrote the code of the

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clien

default SAP userid
hi,, I just like to know if it is ok to use the default SAP user id (SAP*)?

Sessions Value Not Saved
Hi,

Im making a login form and im using this code:
Code: if($login=="true"){

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

Supress some serveroutput but not all
Hi,

I have a script I'm working on that uses plsql to create and RMAN script, this uses d

Display error above the login forum help!
Hi guys. just so you know im not asking for someone to do this for me I just need to be pointed in t

mysql query with single quotes in a variable
$sitedetails = "INSERT INTO vars (address, sitename, description, ownername, theme) VALUES ('$u