On 1/11/2014 2:46 PM, George Wilson wrote:
Hi Jim,
With all due respect, I think you have made some good arguments and I would
tend to agree with you. All things considered, usually using a default
value like that will be a liability later. However, we dont know what this
guy is up to. There could be good reason for using that default date.
Perhaps he or his boss wants a value there because of database or indexing
constraints and they do not have control of the schema- who knows. The guy
asked his question with the particular conditions he is interested in.
Perhaps your arguments will sway him but is there really a need to grill
the guy?
On Sat, Jan 11, 2014 at 11:09 AM, Jim Giner <jim.giner@xxxxxxxxxxxxxxxxxx>wrote:
On 1/10/2014 4:53 PM, Robert wrote:
I have a date field on an html form that users may leave blank. If they
do leave it blank I want to write the date 01/01/1901 into the mysql
table. How can I accomplish this and where in my .php script file should
I put the code?
Thank You,
Robert
flahurr@xxxxxxxxxxx
Robert,
It really makes no sense to post a completely fabricated value into your
date field to represent 'the absence' of a date. From now on you will be
forced to mask that value OUT of your output displays since I'm fairly
certain you will not want to show people that silly date value. Do you
realize that just leaving the date = null you will accomplish the same
thing and you won't have to 'hide' it when you call up a record and send it
to the client?
Can you give us one valid reason that you wish to do this thing?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I can only attribute his choice of this behavior to inexperience and am
trying to give him something to think about before proceeding.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
