I am writing a script that allows my client to update live events that he will be playing at, for the table i have made in mysql i have used datetime to hold this value as both a date and a time need to be passed. what is the best way of making sure that a user enters these values in a correct manner and then combining these values to become one variable. i was thinking that a select menu would be best as that way the client cannot make mistakes, and making one select menu for date and one for time.
Would this be the best way ??,
how could i append the date variable to the time variable??
if a select menu is the way to go does anyone know of a script i can use to save me having to hard code the whole thing myself.
Thanks