FUDforum: comp.lang.php » Edit a record?

Home » Imported messages » comp.lang.php » Edit a record?

Show: Today's Messages :: Polls :: Message Navigator

Re: Edit a record? [message #176204 is a reply to message #176199]

Sat, 03 December 2011 18:57

Beauregard T. Shagnas
Messages: 154
Registered: September 2010

Karma:

Senior Member

Charles wrote:

> I'm working on an application. I'm trying to implement an update
> [snip]
> Month_of_birth
> Day_of_birth
> Year_of_birth
>
> Anyone have any ideas they'd care to share?

Why the three separate fields? Just use a single DATE field (name it DOB
or similar) and if/when you need to report on it, simply pull out the
month or day or year parts in your SELECT query. Much easier to maintain.

Trying to arrange, say, a sort by birthdate with your method is much more
difficult.

--
-bts
-This space for rent, but the price is high

Report message to a moderator

[Message index]

		Edit a record? By: Charles on Sat, 03 December 2011 13:28
		Re: Edit a record? By: Luuk on Sat, 03 December 2011 13:45
		Re: Edit a record? By: Denis McMahon on Sat, 03 December 2011 14:15
		Re: Edit a record? By: Beauregard T. Shagnas on Sat, 03 December 2011 18:57
		Re: Edit a record? By: Arno Welzel on Sun, 04 December 2011 13:54
		Re: Edit a record? By: Dennis on Sun, 04 December 2011 14:14
		Re: Edit a record? By: Charles on Sat, 10 December 2011 13:02
		Re: Edit a record? By: The Natural Philosoph on Sat, 10 December 2011 19:22

Previous Topic:	regex help
Next Topic:	Upload xlsx /xls and save to DB using minimum memory?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 02:07:24 GMT 2024

Total time taken to generate the page: 0.05156 seconds