Re: [PHP-DB] Time input formatting in PHP-12 hour clock

2003-06-22 Thread David Shugarts
With help from the List, I have had some success in answering my question about formatting 12-hr vs. 24-hr time and I thought I would share these two examples of what is working for me. The first example keeps the user from inputting invalid data. In the second, I note that an error yields a "-1" b

RE: [PHP-DB] Time input formatting in PHP-12 hour clock

2003-06-13 Thread Carl Furst
Message- From: David Shugarts [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Time input formatting in PHP-12 hour clock Hi, All-- Has anyone already solved the problem of how to get a time input from the user in people time (12-hour clock) an

Re: [PHP-DB] Time input formatting in PHP-12 hour clock

2003-06-13 Thread Ronan Chilvers
Hi David Comments inline... On 13 Jun,2003 at 10:26 David Shugarts wrote: > PHP--I need the user to be able to input a time, then validate it as to > whether it is complete (e.g., expresses AM or PM and evaluates correctly), > then pass it into an INSERT statement into the time field of a datab

[PHP-DB] Time input formatting in PHP-12 hour clock

2003-06-13 Thread David Shugarts
Hi, All-- Has anyone already solved the problem of how to get a time input from the user in people time (12-hour clock) and format it to be INSERTed in a mySQL time field? The mySQL time field is 24-hour and of course it can be formatted in the SELECT statement to be displayed as 12-hour for the