News database updated multiple times throughout each day. The database has a date field and time field, when sort on date is used it randomly rearranges the post time.
Do I have to modify the $get_unix_date subroutine or is there a way that I can combine date and time into one field?
I am probably missing the obvious, I have been working non-stop on DB Man for the last three days.
Also, is it possible to search for just the MONTH in a date field? For example , I am having problems when I enter the key word May in search all fields, hit submit and it fills in all search fields with may but doesn’t search the database and gives no error. For the time being I just switched the date field type to ALPHA and that solved the search problem. Not a long term solution!
Any help on how to setup this sort will be massively appreciated.
Cheers!
------------------
Larry "NgtCrwlr" Mingus
www.makeitsimple.com
Do I have to modify the $get_unix_date subroutine or is there a way that I can combine date and time into one field?
I am probably missing the obvious, I have been working non-stop on DB Man for the last three days.
Also, is it possible to search for just the MONTH in a date field? For example , I am having problems when I enter the key word May in search all fields, hit submit and it fills in all search fields with may but doesn’t search the database and gives no error. For the time being I just switched the date field type to ALPHA and that solved the search problem. Not a long term solution!
Any help on how to setup this sort will be massively appreciated.
Cheers!
------------------
Larry "NgtCrwlr" Mingus
www.makeitsimple.com