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

Preg_match with an array
is there an away to use preg_match with an array?

i want to check a string with an array to s

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

Help a newbee save my job !
Hey guys i am dying here i am new to php and would like for someone to help me with this problem

A Few Questions
Hi, I want to ask a few questions that I can't seem to find..

1) I'm creating a "shortcu

TemplatePower & AJAX
Hi all,



I'm currently implementing some AJAX features in my PHP-framework (which is b

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

Syntax Help
Code:


im having trouble with that code snipped
Parse error: syntax error, unexpec

Most basic form question ever?
Hello,

I want to use this snippet to make sure the fields in a form are ok before processing

problem in program for counting no of chars using pointers
Hi all, I was trying to make a program which counts number of chars in a string using concpt of poin

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to