PhoenixTwo Posted January 24, 2008 Share Posted January 24, 2008 Hi there, I have come to a brick wall within my coding. I have written a search page and I want to expand on it. What I am trying to do is check to see whether the search string is a date (format: XX/XX/XXXX) and if that comes out true, then search the database for that particular date. The dates within the database are in three different fields (dd, mm, and yyyy). Can someone please show me the way of checking to see whether the string is a date or not, and then going through the proper search routine. Thanking you all kindly in advance for the help. Quote Link to comment Share on other sites More sharing options...
rajivgonsalves Posted January 24, 2008 Share Posted January 24, 2008 you should use the STR_TO_TIME function in mysql... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.