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

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

Struct/union and scope problem!
HI all , I have
Code: in header.h typedef struct Node Link; /* ---------

Sessions Value Not Saved
Hi,

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

Line break?
Hi, I'm new to the forum and new to php. I'm not sure if I'm using the correct terminology so here i

retrieving more than one max key from an array?
so i have an array of 20 numerical values (0-100) that i need to order from highest to lowest and th

Multiple websites question.
Hi, does php have any functionality that enables a programmer to extract information from a website

reating a background image
I am building a site in drupal and have a php form in it, due to certain annoyances with module buil

DOMDocument
Hello All,

I need to take an XML document, modify some of the nodes in it and then perform a

Delete records not in top 15
Hi,

I'm creating a hall of fame page in my game and the page will only display the top 15 sco

upload form file types....
Hey all, I am learning PHP and I am writing a script from the W3C Schools tutorials for uploading fi