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

Optimize Code
Just started getting into the use of cookies. The following code will redirect users to a set URL s

How to separate records and ORDER BY
Let say i have 100 records and displayed in one page, then i want to get the records from 50-100 and

CHECK A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

Accessing element of object array
Hello

My object looks like this:


Array ( [0] => User Object ( [id] =>

MFC GUI Programming
I am working on a project right now that requires me to create a MFC Windows GUI. Basically it need

How to find OS bit version
How can I tell the person browsing my site is running 32, or 64 bit operating system?

Alternate messaging
I have 4 strings in MySQL db1

$string1 : Hello
$string2 : Hi
$string3 : Great
$strin

how do I show what a user have selected from a checkbox?
From my code below, how would i show which check boxes have been checked and which radio buttons sel

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai