PWD Posted March 7, 2006 Share Posted March 7, 2006 Currently developing a GUI where my client can add important dates to their calendar. The info. is stored in a MySQL table where the field attribute is set to DATE.I have 3 select boxes. 1 for the Month, 1 for the Day and 1 for Year. When submitted, I need to make their choices into one; international date format. Here is what I have so far:[code]$impdate = $_POST['impyear'] . $_POST['impmonth'] . $_POST['impday'];[/code]Let's say they have April 1 2006 selected. As my script stands, when echo'd it produces the following:[code]200641[/code]My PROBLEM: How do I get the dashes in there also so MySQL recognizes it as a valid date format:[code]2006-4-1[/code]My gratitude ahead of time! Quote Link to comment Share on other sites More sharing options...
insrtsnhere13 Posted March 7, 2006 Share Posted March 7, 2006 i think it would be something like[code]$year."-".$month."-".$day[/code] Quote Link to comment Share on other sites More sharing options...
PWD Posted March 7, 2006 Author Share Posted March 7, 2006 You are the...PERSON! My gratitude for helping me learn...(bows gracefully) 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.