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

Word Trimming
Hi Guys & Gals!!

Hope you are all ok....

I need some help with the following

MySQL issue
I am taking sentences through a form on page. Then checking some condition and trying to insert them

Hit counter updating once per IP - IP HIT COUNTER
I have a hit counter, for the amount of views on a tutorial.
It'll do the query and then do..

Number Format
Hi All,

I have number '000000000050085' I want to format it to 500.85 Can any one give me

Gaining access to Drop Down Menu Variable
code is below, I am creating a drop down menu. I want to echo the value selected in the drop down me

jquery validation in codeIgniter
hai i need to add client side validation to my fiels which are selected in a forloop.the fields are

Error: SQL Syntax; Line 1
Code:

<?php require "global_settings.php"; ?>
<title&g

quotes changing
hi all

in my content

opening quotes " changes to “

close qu

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

How to kill asynchronous postback / current postback?
Hi,here is my problem:I have a web site with many pages of which some may take time to process resul