I am a newbie still at this so I will say it the best I can...
I was creating a guestbook using php and mysql, I wanted to display the date of each post on them. I created a time and date table, the time type was set to time and the date type was set to date, nothing more to the tables, other than they both were not null.
The problem is that they all show zeros. 0000-00-00 00:00:00
here is the link to my guestbook page, as you can see i have tested the guestbook alot, haha.
http://chibibel.co.cc/guestbook/index.php
I am guessing if you need code you can view the source for that or I will show you what you need...
BTW, the last two posts only have times because they were inserted inside phpmyadmin, not with the form that I have, and I set the function to show the date and time as "NOW"