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

noob cURL help
I have a pretty basic form that I need to cURL post to a file in my includes folder (includes/login.

Having Problem with Date
l have a submit buttom where user have the possibility to add a date to specify when his message s

help need on ob_start()
Hi

I am a newbie in php, I have a code
Line number On/Off | Expand/Contract <?phpo

php - xml what is the best way to do this.
IN essence I want to have a script calling the info from the database.. I have no problem thus far,

I face problems to extract data from one table and insert it in another one
Hi,

For modifications, I have to extract data from one table and insert it in another one

Text to picture Generator
Hello, i have found this script and it works really good^^ But i have one problem, i would like to c

Calling variables
I want to call this to my website but it doesn't display what I want it to,

Code: <h5&

regex for quoted text within a string
I am still getting the hang of regex expressions, but I cant seem to figure out how I would escape q

POST into Array problem
Hi Chaps,

I have a repeat region, displaying rows of data: jobid, fromtable, translatorcharge

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c