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

making web pages for accounts
Hello, I would like to make pages for accounts on my website im making (its not a real website..im j

cookie problem
I hv a website url
In this site main menu functionality based on cookie when user click on parti

Linked Keywords
I am trying to get a script that makes my predefined keyword converted to links and / or converted t

using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto

Linking with Foreign Keys
I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name v

is_dir() problem
Hello,

I'm buidling a php scripts that dynamically get's subfolders from a specific folder.

calendar dates and hours compare problem
i have a calendar in wordpress, everything works great except that i can make 2 meetings at the same

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

batch file not building to webapps folder
Hello. I just started running Vista :P and can't seem to get my projects deployed. I found out how

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass