I 'm trying to create a form that forces a user to insert the date in the correct MySQL format (i.e. 0000-00-00). To do this, I'd like to create 3 menu select items (year, month and day)to join these three inserted values.

Can someone help me use a Dreamweaver MX 2004 behavior to craft the correct PHP syntax to take the values from these 3 menu items, string them together and then insert them into my table's date field? I know it will probably involve some type of an array, a concat statement or a implode of some sort but I'm not having any luck with everything I've tried in what I thought would be a straightforward and simple task.

Thanks in advance.

Why are you wanting to use that format specifically. Won't MySql take standard formats?