[SOLVED] timestamp mysql db

[farkewie]

Hello,

 

I think this will be something simple i just want to add a timestamp to my db when i add or edit something in there.

 

im not sure on what the mysql db col should be set as or the code i should be using.

 

ATM i have

 

date varchar 25

 

and

 

<?php
include ("../sql.php");
mysql_select_db($databse, $connection);
$sql = "UPDATE content SET cat='".addslashes( $_POST['cat'] )."', title='".addslashes( $_POST['pname'] )."', body='".addslashes( $_POST['body'] )."', date=NOW(), uname='".$_COOKIE['username']."' WHERE id='".$_POST['id']."',";

if ($result = mysql_query($sql)) {

header ("Location:".$_SERVER['HTTP_REFERER']."");
exit;

}

else {

echo "Could Not add page<br> Error :  ".mysql_error()."click <a href=".$_SERVER['HTTP_REFERER'].">Here </a> to go back ";
exit;
}
?>

[mem0ri]

Change date to an INT...I go with INT 11

 

...then just insert time() anytime you run an update.

[farkewie]

Thanks but how do i now display that correctlylater? eg; 20/12/07 14:21

 

and if i sort by this now they should display in propper chronilogical order?

[farkewie]

It's ok,

 

i have got it working here is my code (example)

 

<?php


$q = "SELECT  * FROM table ORDER BY date";
$r = mysql_query($q);
$row = mysql_fetch_assoc($r);

echo date('d-M-y H:i', $row['date']);

?>

 

http://nl2.php.net/date