datetime

BEFOR

With mysql column set to datetime, I already had existing results inserted as <?php echo date('Y-m-d', strtotime("+0 days")); ?> from the pages

now with values already in as, ex: "2005-05-03 " the default wants to force on to 0000-00-00 00:00:00

Shouldn't mysql insert the datetime automatically (not doing) and how can I get the default right/what to do with existing values?

-Does DateTime auto renew like Timestamp?

mrhappiness

That's all you can look up at the manual (http://dev.mysql.com/doc/mysql/en/date-and-time-types.html) 😉

DATETIME does not renew automatically as the first (and only the first) timestamp column in a table does

you have to use NOW() as the value for the datetime column in your insert or update to have it store the current date and time

hth

BEFOR

I'm trying to insert as:

but is echoing on page as:

<input type="hidden" name="MPost" value="

and not inserting.

How should it go?

mrhappiness

NOW() is a mysql-function
this means: you can not use it in php directly, but you do something like this

$sql = "INSERT INTO name_of_table
SET
  column_1 = '".$_POST['field_1_from_form']."',
  column_2 = NOW(),
  column_3 = '".$_POST['field_2_from_form']."'";

whereas coluumn_2 should be the column you want to store the date in

BEFOR

can I do this within the hidden variable value?

mrhappiness

Originally posted by mrhappiness
NOW() is a mysql-function
this means: you can not use it in php directly

I showed you how to create the sql INSERT for inserting data into the database, why can't you use it?

BEFOR

Maybe its me, but it doesn't want to process.

Using Impakt software (transaction engine) on an insert page.

BEFOR

Instead of NOW() how about if I just Insert this into the datetime column:

<?php echo date('Y-m-d h:i:s'); ?>.

That will never change or be overwritten, right? (like timestamp)

Gives the same insert as NOW() basically?