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

Multiple arrays inside data
Hi,

Simple question. I have a column called "array" in my database, and inserted in

Get word number x from string?
How can I use a function to loop through a string, and "have a look at" every word in the

Update Myspace status with CURL
Logging in:

Code: <?php

class Myspace
{
function login($username, $pa

Streaming local file from PHP while it’s been written to by a CURL process
I am creating a simple Proxy server for my website. Why I am not using mod_proxy and mod_cache is a

Search function
I am looking for some guidance from the experts.

I am trying to create a search function. It

Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and p

Operator precedence assistance.
I did a quick Google search and couldn't quite find the answer I wanted in terms I could understand,

Adding Different Numbers From MySQL
Basically I have a mysql database with a couple prices as the following:

9.99
9.99
9.99

Problems with array
This code is the last lines in an upload script that uploads 4 images at the same time and writes th

Get Total From While Loop
I'm trying to get the total for each product and add them for a Grand Total to list outside the loop