Completely Confused by Date Functions
Posted: Tue Jun 19, 2007 3:19 pm
I have looked at several of the tutorials on using dates with PHP and MySql and I'll admit I am lost.
I have a date field in my database that is receiving the data from a desktop application and the data is being stored correctly on my server in the following format - 2007-06-18 - now I want to give users the ability to pull data by a range of dates.
Since php passes the data in strings I assume I must use a function of some sort, but I'm not sure which one or should I use a MySql function or a PHP function? Would someone please point me to a concise tutorial or a sample code that I could study?
Thank you
I have a date field in my database that is receiving the data from a desktop application and the data is being stored correctly on my server in the following format - 2007-06-18 - now I want to give users the ability to pull data by a range of dates.
Since php passes the data in strings I assume I must use a function of some sort, but I'm not sure which one or should I use a MySql function or a PHP function? Would someone please point me to a concise tutorial or a sample code that I could study?
Thank you