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
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
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
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