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

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

PHP - MySQL Fail
My PHP code will only execute the first part of my code...

Code: <?php

sessio

how can i display php source code snippets ?
I am outputting some pho code .. and I want to display the source code so people can copy and paste

phpmailer class & pop.gmail.com?
Code: <?php
$mail->IsSMTP();
$mail->Host = "pop.gmail.com";

Text to picture Generator
Hello, i have found this script and it works really good^^ But i have one problem, i would like to c

word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wor

writing my own sobel filter convolution - something is wrong
I am trying to keep it very simple, I cant see anything wrong with my logic, could anybody help poin

Most basic form question ever?
Hello,

I want to use this snippet to make sure the fields in a form are ok before processing

php global variable
how can we create global variable so we can use its value in any form.. Please give example to

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w