I get blank TIMESTAMP whene i insert!

Chrysanthus

Hi im trying to get the TIMESTAMP in mysql to work but i cant i Just gets allot off this 00000000

what can be worng!

<?
function addpost () {
global $password,$email,$username,$post,$topicID;
	$timestamp = time();
	$new_password = addslashes($password); 	$new_email = addslashes($email);
	$new_name = addslashes($username);
	$new_post = addslashes(nl2br(htmlspecialchars($post)));
	$insert = mysql_query("INSERT INTO newspost VALUES ('NULL','$topicID','$new_name','$new_email','$new_password','$new_post','$timestamp','NULL or whatwere thats works')");
	if (mysql_error() != "") {
		showheader("MySQL Error ".mysql_error());
		?>
		<br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
		<?php
		showfooter();
		exit;
?>

Here is my mysql Table

CREATE TABLE newspost (
ID int(5) DEFAULT '0' NOT NULL auto_increment,
TopicID int(5) DEFAULT '0' NOT NULL,
username varchar(50) NOT NULL,
Email varchar(50) NOT NULL,
password varchar(50) NOT NULL,
Post text NOT NULL,
postorderstamp varchar(10) NOT NULL,
postdatetime TIMESTAMP(14) NULL,

PRIMARY KEY (ID)
);

Norman_Graham

Hi Chrysanthus

The thing with timestamp is that it works if you leave it alone. As soon as you enter a value for a TIMESTAMP field, timestamp is overridden. You want this:

INSERT INTO newspost ('TopicID','username','Email','password','Post text','postorderstamp') VALUES ('NULL', '$topicID', '$new_name', '$new_email', '$new_
password', '$new_post');

You can't enter a timestamp into a TIMESTAMP field, because the MySQL server creates the timestamp as a reaction to data entry into a row.

HTH

Norm

Chrysanthus

If i keep the code like exmpel 1 and leave it TIMESTAMP alone i get MYSQL error like this

MySQL Error Column count doesn't match value count at row 1

if i make the code look like exampel 2. this i dont get a error
But i get empty TIMESTAMP...

I have no ide whatsowever how to fixa this problem

exampel 1.


<? 
function addpost () { 
global $password,$email,$username,$post,$topicID; 
    $timestamp = time(); 
    $new_password = addslashes($password);     $new_email = addslashes($email); 
    $new_name = addslashes($username); 
    $new_post = addslashes(nl2br(htmlspecialchars($post))); 
    $insert = mysql_query("INSERT INTO newspost VALUES  ('NULL','$topicID','$new_name','$new_email','$new_
password','$new_post','$timestamp')"); 
    if (mysql_error() != "") { 
        showheader("MySQL Error ".mysql_error()); 
        ?> 
        <br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p> 
        <?php 
        showfooter(); 
        exit; 
?>

exampel 2.

<?
 $insert = mysql_query("INSERT INTO newspost VALUES  ('NULL','$topicID','$new_name','$new_email','$new_
password','$new_post','$timestamp','NULL')"); 
?>

Chrysanthus

I fixt my problem with this coden!

<?

function addpost () {
global $password,$email,$username,$post,$topicID;
	$dst = 0; 
	$timestamp = gmdate("Y-m-d H:i:s", time() + 3600 + $dst * 3600); 
	$new_password = addslashes($password); 	$new_email = addslashes($email);
	$new_name = addslashes($username);
	$new_post = addslashes(nl2br(htmlspecialchars($post)));
	$insert = mysql_query("INSERT INTO newspost VALUES ('NULL','$topicID','$new_name','$new_email','$new_password','$new_post','$timestamp','NULL')");
	if (mysql_error() != "") {
		showheader("MySQL Error ".mysql_error());
		?>
		<br><p><center><b>There was a MySQL Error -- <?php echo mysql_error() ?></b></center></p>
		<?php
		showfooter();
		exit;