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

Posting Serialized Data Not Working
I am trying to send an object from one PHP file to another using POST. I serialize the object and th

Menu restriction
How can I restrict the individual menu that would appear when a user logs in so that all users are c

Problems with returning true or false in eval()'d code
Hi guys,

Would appreciate some help with a problem when running eval() on a function that sho

SELECT * FROM users WHERE Users are not in Blocked
How do I select all users from users table where there users_id is not stored in the block table

Include a php
Hello,

I'm trying to include a function that shows the recent searches.
Example I have <

Namespace Problem
I'm having problem with a section of code with a variable namespace.

This code works fine:

Refining of search Criteria
Dear Friends

I need a help, I have a search page which of cars related, which has different s

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t

Doubles are giving me problems
Ok so, first of all i made a double = 0.05, but when running the debugger it shows up as 0.04999. I

get font info from a font file
hello,

Does anyone know how to get font info from a font file ... using php of course !
<