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

PHP and XML image gallery variable issue
I'm trying to display the large image on the same page as the thumbnails, to do that I'm passing a v

Memory Allocation
Hi folks,
see this ex:

int v=5;
v=v+10;

then what will do the compiler before th

login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php

i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");

error_reporting(E

INSERT data problem!
After having an string with apostrophes ', double quotes " or any other special characters, suc

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

Using the $_GET variable to view certain records
Hello,

First let me explain my problem, I have 2 pages the first page pull a list of Guide ti

PEAR Email Attachment w/ $gpg
I have no issues with this code if I take out the attachement section and include the info in the em