Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #4001

Re: Edit a record?

Show all headers | View raw

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

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Edit a record? Charles <cchamb2@gmail.com> - 2011-12-03 05:28 -0800
  Re: Edit a record? Luuk <Luuk@invalid.lan> - 2011-12-03 14:45 +0100
  Re: Edit a record? Denis McMahon <denismfmcmahon@gmail.com> - 2011-12-03 14:15 +0000
  Re: Edit a record? "Beauregard T. Shagnasty" <a.nony.mous@example.invalid> - 2011-12-03 18:57 +0000
  Re: Edit a record? Arno Welzel <usenet@arnowelzel.de> - 2011-12-04 14:54 +0100
    Re: Edit a record? Dennis <nobody@nowhere.invalid> - 2011-12-04 09:14 -0500
    Re: Edit a record? Charles <cchamb2@gmail.com> - 2011-12-10 05:02 -0800
      Re: Edit a record? The Natural Philosopher <tnp@invalid.invalid> - 2011-12-10 19:22 +0000

csiph-web