PDA

View Full Version : While in Mysql...


gigiloumill
08-18-2009, 02: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

edbr
08-18-2009, 03: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

gigiloumill
08-18-2009, 03:00 PM
Thanks E....

gigiloumill
08-18-2009, 04: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

edbr
08-19-2009, 01: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