Hi, I have this script below. I echo in there the date, time, and the message. The message matches what is showin my database. However, the echo that I put on this page doesn't match what it should


That page actually has the echoing. The recall.php is taking from the database and is showing a whole bunch of 0's in place of date/time. The checkInfo.php when you go there shows what the actual date() and time() is, and what SHOULD be entered into the database.

This is my recall.php
include "config.php";
$link = mysql_connect($host, $username, $password);

if(!$link){echo "link";die(mysql_error());}
$db_selected = mysql_select_db($DbName, $link);
if(!$db_selected){echo "dbselect";die(mysql_error());}

$query="SELECT * FROM userSubmitted";

$result=mysql_query($query) or die(mysql_error());


while ($i <= $num) {


echo $fieldOne;
echo "<br>";
echo $fieldTwo;
echo "<br>";
echo $fieldThree;
echo "<br>";
echo $fieldFour;

echo "<br><br>";

echo "end of script";
I have this code for checkInfo.php
<?phpinclude ("config.php");
<!doctype html>

$date = date("Y/m/d");
$time = time();

$link = mysql_connect($host, $username, $password);

if(!$link){echo "link";die(mysql_error());}
$db_selected = mysql_select_db($DbName, $link);
if(!$db_selected){echo "dbselect";die(mysql_error());}
$insertionToDatabase="INSERT INTO $tableName (PostNumber, Date, Time, Content) VALUES (NULL, $date, $time, '$contentOfPost')";

$result = mysql_query($insertionToDatabase);
if (!$result) {
    die('Invalid query: ' . mysql_error());

echo $contentOfPost;
echo "<br>";
echo $date;
echo "<br>";
echo $time;
echo $result;


I can describe my database if you wish. Just 4 columns. PostNumber (auto increment), Date, Time, and Content. Time in the database is a Timestamp, the date is set as a Date.

Oh, just went to my page, apparently someone is having fun with my blog.php, because there are somehow 12 blog posts, and ther eis only supposed to be like 2-3 in there (that were my own)...