MySQL date, and time entry issues.

[dylan]

Hi,


Just a few quick questions about date and time entry using html. What
are the preferred methods of entering time data into a database. Eg,
using two drop-down lists.

And also, can anyone suggest a good date picker, or a datetime picker.
(it has to be a free one)


Thanks,

Dylan

[Daz]

Re: MySQL date, and time entry issues.


dylan wrote:

Hi,
>
>
Just a few quick questions about date and time entry using html. What
are the preferred methods of entering time data into a database. Eg,
using two drop-down lists.
>
And also, can anyone suggest a good date picker, or a datetime picker.
(it has to be a free one)
>
>
Thanks,
>
Dylan

As long as you make the code so that it puts the date into the MySQL
database in the correct format, it shouldn't matter how you choose to
get the information from the user. I personally use 3 or 4 dropdown
boxes, one for the day name (if applicable), one for the week day of
the month, one for the month, and one for the year. My script
dynamically generates the dates it needs to put into the boxes when
needed, and validates it on submition.

If you were really feeling creative, it should be quite simple for you
to create your own calander, using PHP's built-in time and date
functions. This way it works and looks how you want it, rather than how
someone else felt it should look, and be used, and you can always add
more to it or remove functionality if you make it a class.

Good luck!

Daz.