Current_date

cap97

I have a date field called simply enough, Date. (I never claimed to be original!) I also have a form that deals with this field. When people enter new information in this form, I want to automatically have the current date entered along with the info the user is entering. (And no, I don't want to use TIMESTAMP!) In MySQL, if I do the following, getting the current date is no problem:


INSERT INTO sit_news SET
News = "Hey, there's new news!",
Date = CURRENT_DATE;

So I figured, if I imbed "CURRENT_DATE" in a hidden form field, then it would insert that along with the rest of the typed in data when the user hits submit. However, it's not working. All the typed data gets submitted just fine, but the date comes up as 0000-00-00. :mad: I used this as my hidden line:


<INPUT TYPE=hidden NAME=Date VALUE=CURRENT_DATE>

Anything wrong with that?

anthill

Hi cap97,

Can't you just use date() and update it in the database. Like:


$member = "John";

$news = "Johns Phat article";

$db = mysql_connect("localhost","username","password");
mysql_select_db("database",$db);

$today = date("l jS F");

$query = mysql_query("INSERT INTO table (member, date, news) VALUES ('$member','$date','$news')");

mysql_close($db);

Kinda thing??

Hope that helps

Ant

cap97

It did help. Not exactly how you think, but it got me to think of something else. Instead of putting a hidden value of "CURRENT_DATE", I just put "CURRENT_DATE" and one of the insert values. Works just fine now, so thanks for the help!

jonsof

Why don;t use the now() function through SQL?

$query = mysql_query("INSERT INTO table (member, date, news) VALUES ('$member',now(),'$news')")

cap97

Originally posted by jonsof
Why don;t use the now() function through SQL?
$query = mysql_query("INSERT INTO table (member, date, news) VALUES ('$member',now(),'$news')")
[/B]

Exactly! That's what I did. CURRENT_DATE and now() are the same thing.