Adding dates to mysql

[nuttycoder]

Hi I am trying to auto date dates into the database with every entry but so far all can  get is 0000-00-00 00:00:00 using datetime data type.

 

Here is my code for inserting into the databse

 

if(isset($_POST['Submit']))
{
   $newsTitle   = $_POST['newsTitle'];
   $newsCont = $_POST['newsCont'];
     
   if(!get_magic_quotes_gpc())
   {
      $newsTitle   = addslashes($newsTitle);
      $newsCont = addslashes($newsCont);
   
   }
   
   
   $query = " INSERT INTO news (newsTitle, newsCont, newsDate) VALUES
   ('$newsTitle', '$newsCont', '$newsDate')";
   
   mysql_query($query) or die('Error ,query failed');

   echo "'$newsTitle' added";
}
?>

<table width="71%" border="0" align="center">
  <tr>
    <td>

<form  method="post" action="insert-news.php">
<input type="hidden" name="newsID" value="<?=$newsID;?>">
<p>News Title <br />
<input name="newsTitle" type="text" size="40" maxlength="255" >
<br />
<br />
News Content<br />
<textarea name="newsCont" cols="80" rows="15" id="newsCont"></textarea>
<input type="hidden" name="newsDate" value="<?=$newsDate;?>">
<br />
<input type="submit" name="Submit" value="Add News">
</p>
<p align="center"><a href="../stories">Back to Admin</a></p>
</form>
</td>
  </tr>
</table>

 

Any help on guide me where am going wrong would be great

 

Thanks

[Wildbug]

You want timestamped rows?  Either use the TIMESTAMP column type which will automatically set itself on an INSERT or UPDATE or a DATETIME column (like you already have) using the NOW() function when you INSERT the row.

[nuttycoder]

Thanks

 

I tried doing the NOW()

 

<input type="hidden" name="newsDate" value="<?= NOW();?>">

 

but that gives me Fatal error: Call to undefined function:

 

 

[Wildbug]

Eh... NOW() is a MySQL function.  And don't put it in the form; put it in the code that inserts the row.

 

<?php

$query = "INSERT INTO news (newsTitle, newsCont, newsDate, timeStampColumn) VALUES ('$newsTitle', '$newsCont', '$newsDate',NOW())";

?>

[nuttycoder]

 

I have changed my table structue to use timestamp and have changed my sql query to match

 

<?php
$query = "INSERT INTO news (newsTitle, newsCont, newsDate, timestampColumn) 
   VALUES ('$newsTitle', '$newsCont', '$newsDate',NOW())";
?>

 

but now the request just fails.

 

 

[Wildbug]

Have you checked for errors?  If so, what are they?

 

<?php

$query = "INSERT INTO news (newsTitle, newsCont, newsDate, timestampColumn) 
   VALUES ('$newsTitle', '$newsCont', '$newsDate',NOW())";

mysql_query($query) or die(mysql_error() . "<br />\nQuery: $query");

?>