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

How to get variable value on next page
Hello friends
i am working on payentry page ..there i have this code.........

How do i do multi uploads?.
Hey i would like to do this : http://hosting.mrkrabz.net/

I've got the base down you can uplo

Varible in trigger - refering to correct schema
Hello

Im having some issues with my trigger.
What I want to do is call opon a differ

Problem with variable declaration in switch statement
Hello, I am having some trouble assigning a value to a variable inside a switch statement. What I a

Map.php
I am a complete beginner to PHP and am looking for some help with a program I am messing around with

Sessions Value Not Saved
Hi,

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

php code generators
All

Whilst enjoying learning a new language i have come accross a number of free code generat

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i

Easy administration on MySQL databases
My website is database driven and I am very tired of manually making queries to my tables in order t

help retrieiving results and doing pagination
Having some trouble trying to get the results to show on more than just one page.

What is ha