Store the date in the mysql data base in text field in this format yyyymmdd
and use a string compare for detecting expired files.
//$date = get date from mysql
if ($date < '20051223') {}
use a substring routine to convert the date string when needed for other
things.
----- Original Message -----
From: "davidabroad" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, September 23, 2006 4:03 AM
Subject: [php-list] Re: setting automatic date (timestamp) on db from form
> Thank you Brian for your reply. However...
>
> I find that this only works if the field in the db table is set up as
> "text" when I need it to be set up as "date" (or something similar)
> because I also need to be able to have these same items "expire" and
> stop showing up on a list after 15 days or so.
>
> Any further thoughts?
>
>
>
>
>
>
> Community email addresses:
> Post message: [email protected]
> Subscribe: [EMAIL PROTECTED]
> Unsubscribe: [EMAIL PROTECTED]
> List owner: [EMAIL PROTECTED]
>
> Shortcut URL to this page:
> http://groups.yahoo.com/group/php-list
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/php-list/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
