\n\n";
while ( $cat = mysql_fetch_array($categories) ) {
$categories_select .= "".$cat['category']."\n";
}
$categories_select .= "\n";
$form_elements = array(
"FormTag"=>"
'))."',
diary_date='".date("Y-m-d", strtotime($_POST['diary_date']))."',
time_modified='".date("Y-m-d H:i:s",time())."'
WHERE entry_id=".$_GET['id'].";";
mysql_query($query);
$returnid = $_GET['id'];
} else {
//No ID for the entry so we need to INSERT a new one!
$query="INSERT INTO entries VALUES(
null,
'".addslashes(htmlspecialchars($_POST['subject']))."',
'".addslashes(strip_tags($_POST['body'],''))."',
'".$category."',
'".date("Y-m-d", strtotime($_POST['diary_date']))."',
'".date("Y-m-d H:i:s",time())."',
null)";
mysql_query($query);
$returnid=mysql_insert_id($connection); //ID of the new entry!
}
//Send the user back to the view. Equivalent to a $$Return field!
Header("Location:".$_SERVER['PHP_SELF']."?id=".$returnid);
} else {
die("Your request method is not supported by this page!");
}
?>