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

Hardcopy printing is to wide
I want to make a hardcopy at runtime of my active form like this

Comparing two dates
Hi Guys
I have two dates I want to compare. Below is my current implementation. The problem with

losing variables between php brackets
Hi

have got this code:
Code: $id=mysql_result($result,0,"itemid");
$title=mys

Fetching META TAGS through
Hello everybody
I want to fetch meta tags of a domain.
It will be done from following code of

MII Trends - add data onto chart object
Hello,

Can anyone please provide some thoughts on my current requirement:
its pretty

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

some questions
Hello,

I am looking for the answers for following questions:

1) Does PHP support overl

Stopped working!
So I had to change some stuff, none of it major. Stuff like the extension_dir and such. BEFORE I did

How to submit a form to the same page?
I have a table containing information about books in my library and this table has the following col

Curl & sessions PLS HELP
Hello,

I have a problem with curl and sessions and i will try to explain the best i could.