Perad Posted December 21, 2006 Share Posted December 21, 2006 When i create a news article for my site i have the following code mysql query.[code]$query = "INSERT INTO news(postdate, title, newstext, cat_id, author, author_id) VALUES(NOW(), '$t', '$c', '$a_cat', '$username', '$user_id')";[/code]When i edit a news article i have the following query.[code]$query = "UPDATE news SET title='$t', newstext='$c' WHERE id='$id'";[/code]Yet it always changes the postdate as well. Is there a way in which i can update my mysql table without the postdate column being updated as well? Quote Link to comment Share on other sites More sharing options...
HuggieBear Posted December 21, 2006 Share Posted December 21, 2006 Sounds as though it's a timestamp field, change the column type to datetime.Taken from the MySQL Manual...[quote]The first TIMESTAMP column in table row automatically is updated to the current timestamp when the value of any other column in the row is changed...[/quote]RegardsHuggie Quote Link to comment Share on other sites More sharing options...
Perad Posted December 21, 2006 Author Share Posted December 21, 2006 Thanks a lot, that did the trick :D Quote Link to comment Share on other sites More sharing options...
HuggieBear Posted December 21, 2006 Share Posted December 21, 2006 No problem, don't forget to use the 'Solved' button on your post.RegardsHuggie Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.