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()."')");

Other php-forum

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q

Recording popularity by day, week.. all time?
Hey everyone, I'm creating a site designed around users uploading music. How can I implement a syste

Refining of search Criteria
Dear Friends

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

Delete records not in top 15
Hi,

I'm creating a hall of fame page in my game and the page will only display the top 15 sco

strptime() equivalent for php4 ?!
Greetings!

this is my first post, thank you in advance for your replies.

Well, the ti

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at

cURL and Sessions
Ohai.

So, I'm trying to cURL a bunch of things off of a page, and put them into a session. I'