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

Can I call a class inside a function?
I have a class written in another file that handles my image resizing.

Can I do this (php say

include problem
I have my root folder as:
Code: $root = $_SERVER["SITE_HTMLROOT"]; // the server root<

Vertical Alligning - Not working in 1 cell?
<?php

echo "<table id="valign" width="60%" style=

help with image upload code
Hello,

right now this code I have resizes images and then places them into the uploads folder

Extract specific information from a PHP Multidimensional Array
Howdy! I've racked my brain over this for 24 hours now. I think it's time I asked for help. I'm lear

my sql select id and then update problem.
I need to select some auto incremented ids out of a database and then use those id in a where statem

I am stumped
OK. Here is what I am trying to do. I have the conditions set, and if the conditions are met, I want

exclude characters from counting?
Hello, I wanted to ask if you have a string like:
Code: $my_s='ASRGREGTGTR----REGREGRE+++RRRRRR..

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

A little help in c#
i am doing a simple paint program using c# i want to draw with the mouse so i wrote the code of the