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

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

How do I send data using an html link
Hi

If I have
<a href="main_file.php">

How do I send data t

Retrieving innerHTML with cURL?
Hey all (sorry I know I'm a leecher, but I soon won't be. This is my first PHP project, but not my l

Display search result
Hi!

I have a SQL database with information about albums and track (music).

This is wh

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t

PHP mail() rejected by SMTP
I'm currently working on a newsletter application which is installed on a windows 2003 server runnin

BIG file upload!
Hey guys!

I'm trying to upload a file, it works well with smaller files but with 60mb+, I get

Remove directories not empty
hi,
i have an array that contains some names (1,4,6,56...). Every integer is a name of a folder.<