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

Scheduler problems related to execution of a single BLT by many schedules
Hello all,

We are running several MII instances in a distibuted architecture using a sing

Print out contents of to Excel
I have got this script that gathers all the data that I need but I need it to send it to excel inste

Help Ordering Arrays
Hi, I have 3 arrays as shown below.

Code: $users = $this->get_latest_users();
$flir

IP question
ive got 2 ip addresses both global from same user how would i detect if they are local to each other

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

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

GET vs SUBMIT Button to show sections on one index.php page?
Just curious if one of these ways is better (i.e. more efficient) than the other.

I have a

Creating an invoice
Using fpdf I am trying to create an invoice to send to clients. The products are sold in pricing tie

INSERT for date range
Hi all

I have the following table

Code: [Select] `date` date
`day` int(2)
`

Time-based image rotation script
I'm trying to write a PHP script that rotates an image based on what time of day it is. I want the