Inserting Questions

[franknu]

Ok, I have to question in one code the first is. i have this code that at soon as the visitor goes to the page it sent a message i one want them to send a message  if the submit the code for some reason, it is not doing that and the other question is how do i insert actual date and time in the page when the user hit submit

 

here is my code

$from = addslashes($_POST['from']);
  $status= addslashes($_POST['status']);
  $subject= addslashes($_POST['subject']);
  $message= addslashes($_POST['message']);
  $BusinessName= $_SESSION['BusinessName'];
  
if(Submit)
{
$query = "INSERT INTO  `messages` (`BusinessName`,`date`,`from`,`status`,`subject`,`message`)
VALUES ('".$_SESSION['BusinessName']."','".$date."','".$from."', '".$status."','".$subject."',
'".$message."')";
$result = mysql_query($query);
echo mysql_error();
}
if($result)
         {
echo " Your Message have been sent. We will get back to you. <br>";
          }


?>

[supanoob]

the date insert is just NOW()

[franknu]

so i have to do

 

date=NOW();

[franknu]

any idea how to set it up, i really dont know how to set it up

 

because it did

date=NOW(); and i am getting an error

[pikemsu28]

$query = "INSERT INTO  `messages` (`BusinessName`,`date`,`from`,`status`,`subject`,`message`)
VALUES ('".$_SESSION['BusinessName']."',now(),'".$from."', '".$status."','".$subject."',
'".$message."')";

 

now() will insert a timestamp into your database as 'YYYY-MM-DD HH:MM:SS'

 

set your database field 'date' as a DATETIME datatype

[franknu]

ok that works but it only giving me the date, i also want the time on the same input

[pikemsu28]

is your date field set as a DATETIME datatype?

 

if it's just set as DATE, it will not include the time stamp

[franknu]

ok, thank u

[pikemsu28]

no problem