Re: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread graeme
[mailto:[EMAIL PROTECTED] Sent: 28 February 2005 13:31 To: S.D.Price Subject: RE: [PHP-WIN] Validation of Primary Key Datetime variable Simon, Why not use a varchar datatype and populate it yourself. It can then be modified, but the data can still be displayed in the way you want, by being a bit more

Re: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread Randy Clamons
wish? Randy Clamons Systems Programming Novaspace.com > Original Message > From: "S.D.Price" <[EMAIL PROTECTED]> > To: "php-windows" > Date: Mon, Feb-28-2005 6:18 AM > Subject: [PHP-WIN] Validation of Primary Key Datetime variable &g

RE: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread Mike
OTECTED] > Sent: Monday, February 28, 2005 9:17 AM > To: php-windows > Subject: RE: [PHP-WIN] Validation of Primary Key Datetime variable > > Thanks for this George. I am populating the datetime field > from user input, and users can change the date if they need to. > > The

RE: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread S.D.Price
sure what. Steven -Original Message- From: George Pitcher [mailto:[EMAIL PROTECTED] Sent: 28 February 2005 13:31 To: S.D.Price Subject: RE: [PHP-WIN] Validation of Primary Key Datetime variable Simon, Why not use a varchar datatype and populate it yourself. It can then be modified, but

[PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread S.D.Price
Hi, I wonder if anyone can help. I have designed a newsblog which uses PHP and MySQL. Each news story has a primary key which is the current date. The datatype used in MySQL is "datetime". When stories are extracted from the database the user can then navigate based on date order. When a user ad