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

Interpret Order
Hello all,

I'm wondering if I have this:

Code: $switch = array(
'one' =>

b+ tree
Hi
can every body help me about b+ tree ?(insert & delete)

Uploading files/images via forms
Hey all, I am building a database for work that will contain some minor data on plant species along

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

Xacute search within SQL results
I have a query that is pulling data, and I want to return a specific value from the results of that

Time script, set to my time zone?
I am using this line to get the date and time

Code: $time = date(F." ".d.", &q

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

Ajax Issues - Update Panel / Timer. Intellisense doesn't know about them
Type 'System.Web.UI.ScriptManager' does not have a public property named 'UpdatePanel'. That is wha

Error with Font and imagettfbbox
I keep getting an error that says "Warning: imagettfbbox() [function.imagettfbbox]: Could not f

IF Statement & Two Tables With Different Echoes
I'm retrieving two tables in a single query using UNION ALL, like so:

Code: $query = "SE