MySQL Forums
Forum List  »  Newbie

Re: date field in database shows 0000-00-00 00:00:00
Posted by: Arie Nagel
Date: August 18, 2005 02:02PM

Wouldn't replacing '$date' with NOW() do the job?

$sqlquery = "INSERT INTO $table VALUES('$id','$name',NOW())";

That way you don't even need the $date variable.

Options: ReplyQuote


Subject
Written By
Posted
Re: date field in database shows 0000-00-00 00:00:00
August 18, 2005 02:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.