|
Posted by Jerry Stuckle on 11/14/06 22:29
mmckeon@gmail.com wrote:
> Jerry Stuckle wrote:
>
>>merianosnikos@gmail.com wrote:
>>
>>>Is a very good idea but i think that somebody or something must fire
>>>this event . . . Is it posible to be start by it self ? ? ?
>>>
>>>For example i like to meka a table like this :
>>>
>>>$col_a | col_b | col_. . . | col_n | col_expire_date
>>>
>>>When the expire date is the current date delete the record.
>>>
>>>Thanks a lot . . . :D
>>>
>>
>>Just set up a cron job to run once a day and deletes anything with an
>>expiration date of today or before.
>>
>>It's one of the things cron jobs are designed for!
>>
>>--
>>==================
>>Remove the "x" from my email address
>>Jerry Stuckle
>>JDS Computer Training Corp.
>>jstucklex@attglobal.net
>>==================
>
>
> Can you use temporary tables to store your data that is going to
> expire? If so these tables are good for the life of the connection and
> may be useful for what you are doing with your records that expire. You
> can even create one that is just like one of your "real" table:
>
> create temporary table IF NOT EXISTS tmpMyTableCopy LIKE tblMyTable
>
(Top posting fixed)
The only problem with temporary tables is they go away at the end of the
connection. If he wants to use use them again, i.e. on a subsequent
page, they're gone.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|