[SOLVED] Including a timestamp in update?

[chrisuk]

I'm trying to code an update script to store the current time so that this can then be seen by the user the next time they look at that particular record.

 

The code for the script is as follows:

 

<?php

 

include("config.php");

 

$updatetime = date("j M y, G:ia");

 

//code to update record if any changes are made

$sql = "UPDATE Issues SET issue_desc = '$_POST[issue_desc]' , last_update = $updatetime WHERE issue_id='$_GET[issue_id]'";

 

$result = mysql_query($sql)or die("error");

 

?>

 

This produces simply "error" for this code.

 

However if I do not try to write $updatetime to the database, the query executes and issue_desc is updated.

 

Can anybody tell me what i'm doing wrong here?

 

Thanks.

[ted_chou12]

I believe timestamps should be in this format:

"Y-m-d H:i:s"

Ted

[chrisuk]

Thanks for the reply.

 

I altered the timestamp layout but still got the error.

 

I changed last_update = $updatetime to last_update = '$updatetime' and it is now working.

 

thanks anyway