Inserting the current date/time while submitting the forum

Posted on 16th Feb 2014 07:03 pm by admin

What do I need to add below to update the current date/time? I have a field in the database called datetime. I tried to use Now() but its not working.

Code: <?php
$con = mysql_connect("host" , "aaaaa" , "pw");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("aaaaa", $con);

mysql_query("update application set comment='".mysql_real_escape_string($_POST[comment])."' where `name`='".mysql_real_escape_string($_POST[name])."'");

/*This is what I tried to add so that i can directly inject the current date/time*/
$sql="INSERT INTO application (datetime)
VALUES(NOW())";


mysql_close($con)
?>

Other php-forum

PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a

Wierd echo error?
Hi, i got the most wierd php error ever and i don't know why..
Code: echo "<t

Remote Database Access
Hey guys!!

OK, i'm used to only working with databases from the CPANEL, accessing phpMyAdmin

help retrieiving results and doing pagination
Having some trouble trying to get the results to show on more than just one page.

What is ha

javascript in php code causes page to display white
Hi All,

Odd one this, I've got the following code (below) which is a simple log in form. The

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t

Limiting uploaded file type
I am working on a simple upload script, and I need it to limit the allowed file type that is uploade

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c

pls clear my confusion
Hi friends,

Pls solve my query .

what is the exact use of Scope Resolution Operator( i