inserting a timestamp.

cindango

All I get in the date field is 00000000000000. In turn when it's converted I get December 12, 1969. Does anyone know what's wrong?

here's my code:

<?php

$hostname = "mysql.mygisol.com";
$username = "cindang_admin";
$password = "ichiichi";
$dbName = "cindang_news";
$tablename = "news";
MYSQL_CONNECT($hostname,$username,$password) OR DIE("");
@mysql_select_db("$dbName") or die("");

mysql_query("INSERT INTO `news` (`newsdata`, `date`, `title`) values ('".$newsdata."', '".$date."', '".$title."')"); 

$date = mktime();


$result = MYSQL_QUERY($query);

MYSQL_CLOSE();

echo "<META http-equiv=refresh content=0;URL=http://cindango.com/v1/>";

?>

Weedpacket

Could it be because you're not setting $date until after you've already inserted it into the query?

cindango

Originally posted by Weedpacket
Could it be because you're not setting $date until after you've already inserted it into the query?

Still the zeros. 🙁

cindango

here's the form...anything look wrong?

<html>
<head>
<title>cindango.com</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#E2007A">
<table width="100%" height="100%" border="0" cellspacing="0" cellpadding="0" style="color: #FFFFFF; font-family: Arial; font-size: 10pt; border-collapse: collapse" bordercolor="#111111">
  <tr>
    <td><div align="center">
        <table align="center" width="550" border="0" cellspacing="0" cellpadding="0">
          <tr> 
            <td width="514">
            <img src="http://cindango.com/v1/images/header.gif" width="550" height="71" border="0" usemap="#Map" href="http://cindango.com/v1/index.php"></td>
          </tr>
          <tr style="color: #FFFFFF; font-family: Arial; font-size: 10pt; border-collapse: collapse" bordercolor="#111111">
            <td bgcolor="#000000">
<?php
switch($page) {
case 'about':
include("about.php");
break;
case 'portfolio':
include("portfolio.php");
break;
case 'links':
include("links.php");
break;
default:
?>
<table width="550" height="350" border="0" cellpadding="0" cellspacing="0" style="color: #FFFFFF; font-family: Arial; font-size: 10pt; border-collapse: collapse" bordercolor="#111111">
  <tr valign="top"> 
                  <td height="94" colspan="2" bgcolor="#000000" style="padding-top: 10; padding-left: 10;">
                  <img src="http://cindango.com/v1/images/sitenews.gif" width="215" height="94"></td>
  </tr>
                <tr> 
                  <td width="540" height="256" valign="top" bgcolor="#000000" style="padding: 25;"">        <form method="post" action="addnews.php">
                      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; color: #FFFFFF; font-family: Arial; font-size: 10pt" bordercolor="#111111" id="AutoNumber1">
                        <tr>
                          <td width="50" align="right" style="padding-right: 5" valign="top"> 
                            </td>
                          <td width="150"> 
                            <input type="hidden" name="date" size="20" style="font-family: Arial; font-size: 8pt; border: 1px solid #FFFFFF; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; color:#000000; background-color:#C0C0C0">
                          </td>
          </tr>
          <tr>
                          <td width="50" align="right" style="padding-right: 5" valign="top">
                          title</td>
                          <td width="150"> 
                            <input type="text" name="title" size="20" style="font-family: Arial; font-size: 8pt; border: 1px solid #FFFFFF; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; color:#000000; background-color:#C0C0C0"></td>
          </tr>
          <tr>
                          <td width="50" align="right" style="padding-right: 5" valign="top">
                          content</td>
                          <td width="150"> 
                            <textarea rows="10" name="newsdata" cols="25" style="font-family: Arial; font-size: 8pt; color: #000000; border: 1px solid #FFFFFF; background-color: #C0C0C0"></textarea></td>
          </tr>
          <tr>
                          <td width="50" align="right" style="padding-right: 5" valign="top">&nbsp;</td>
                          <td width="150"> 
                            <input type="submit" value="submit" name="submit" style="font-family: Arial; font-size: 8pt; border: 1px solid #FFFFFF; background-color: #C0C0C0"></td>
          </tr>
        </table></form></td>
    <td width="36" valign="bottom" bgcolor="#000000"> 
      <div align="right">
        <img src="http://cindango.com/v1/images/admin.gif" width="37" height="172"></div></td>
  </tr>
</table>
			</td>
          </tr>
        </table>
<?php
}
?>
      </div></td>
  </tr>
</table>
<map name="Map">
  <area shape="poly" coords="4,34" href="#">
  <area shape="rect" coords="9,22,132,68" href="http://cindango.com/v1/index.php?page=about">
  <area shape="rect" coords="137,10,234,67" href="http://cindango.com/v1/index.php?page=portfolio">
  <area shape="rect" coords="237,21,333,67" href="http://cindango.com/v1/index.php?page=links">
  <area shape="rect" coords="374,35,551,63" href="http://cindango.com/v1/index.php">
</map>
</body>
</html>

cindango

Hmm I changed the date field from TIMESTAMP to VARCHAR and now I am at least in the right year. But the month and day are still messed up I'm afraid.

Weedpacket

MySQL timestamps are not the same as the timestamps everyone else (Unix, PHP, etc.) uses.

Try storing it as an INT.

Plus, I don't see where you're setting it. You've got a hidden form field but no value.