antilectual
-
Posts
2 -
Joined
-
Last visited
Never
antilectual's Achievements
Newbie (1/5)
0
Reputation
-
cheers bud
-
on my news manager i have been using CURDATE() to insert the date on which a news item was posted, but now i have changed the column from date to datetime (YYYY-MM-DD HH:MM:ss) and curdate() will not enter the time. is there something else i can use? what does timestamp() do? this is my query at the moment: "INSERT INTO News SET NewsTitle=\'$title\', NewsDate=CURDATE(), UserID=$user_id, NewsText=\'$text\'"; any ideas? cheers, Antilectual