PROS! PLEASE HELP! Backend not printing date in database!

brianb

Hello pros,

I have a bit of an issue...any help would be appreciated!

Basically, I have a form which takes in certain variables for the table. Everything is being inputed correctly, BUT the DATE portion is not being printed!

Here's my code:

<?PHP

$review = (ereg_replace("[\n]", "<br>", $review));	

if ( !$reviewID && !$filmID && !$date && !$blurb && !$review && !$rating && !$person )
{

	//  SOME ERROR MESSAGE
}
else 
{
	if ( $Delete )
	{
		$sql = "DELETE FROM Reviews ";
		$sql.= "WHERE reviewID = \"$reviewID\"";
	}

	else 
	{
		$sql = "REPLACE INTO Reviews ";
		$sql.= "( reviewID, filmID, date, blurb, review, rating, person ) ";
		$sql.= "VALUES ( \"$reviewID\", \"$filmID\", \"$date\", \"$blurb\", \"$review\", \"$rating\", \"$person\" )";
	}
}


if ( $res = mysql_query($sql) )
{
	header( "Location: /movies/filmFINAL.php?filmID=$filmID" );
}
else 
{
	echo "$sql";
}
?>

Now, why won't the date print into the database? Inside my database the DATE filed is set to:

timestamp(14)
Null? YES
Default: NULL

Please help!

Thanks in advance!

zhabala

Show us the final content of $sql variable.

Why do you use a timestamp column type to store date ? You can use a filed with type of date.

Zdenek

Weedpacket

Originally posted by zhabala
Show us the final content of $sql variable.

Why do you use a timestamp column type to store date ? You can use a filed with type of date.

Zdenek

For that matter you could store the Unix timestamp instead as an integer. Then it would automatically be in a form suitable for PHP's date/time manipulation functions without the extra layer of preprocessing needed to get it out of MySQL's terse-to-the-point-of-absurdity timestamp format.