View Full Version : While in Mysql...

08-18-2009, 01:23 AM
Does anyone know how to set up a field in a db to save the time and date. All I need is to ad a field to my db in order to accept the the time and date the field is filled. The one I currently have only returns 00000000000. Thanks

08-18-2009, 02:14 AM
use a timestamp insert ""or date time then you have to insert current date now(). you will need to format the date if you want to echo it out later,
some prefer to get the date with php, split the parts and then enter into a field or fields

08-18-2009, 02:00 PM
Thanks E....

08-18-2009, 03:09 PM
Guys, while testing the e-mail script I forgot to remove the "include () db" and now I have a db with several fields filled in with junk; how can I remove the filled fields? I don't want to delete complete db and start over. thanks

08-19-2009, 12:57 AM
do you use something like EMS,sqlyog or hiedi
with those its easy to manage databaces but it can be done in phpmyadmin