|
|
Posted by Jerry Stuckle on 11/09/07 21:28
trawets wrote:
> On 8 Nov, 22:01, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> trawets wrote:
>>> Hi
>>> I am trying to write something which will enable me to run a php
>>> script from cron which will delete news item entries from a mysql db.
>>> Criteria here is that the script would look at a field 'publish_down'
>>> which has this format '2007-01-29 16:00:08' check this date is passed
>>> and then delete if it is more than 90 days older.
>>> I have tried to come up with something but a little advise would be
>>> grateful
>>> $today = date("Y-m-d", publish_down("-90 days"));
>>> mysql_query("DELETE FROM table WHERE date = '$today'") or
>>> die(mysql_error());
>>> (publish_down = a table field which is a date)
>>> how would I adopt this type of query into php script
>>> please
>>> trawets
>> I'm not sure what you mean when you say "adopt this type of query into
>> php script". It should work pretty much like you have it.
>>
>> Although personally I would not have a column named date (reserved
>> word), would not call the variable $today (it's not - it's 90 days ago
>> and could be confusing), and I would check for date <= '$today', just in
>> case the script doesn't get run one day.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================- Hide quoted text -
>>
>> - Show quoted text -
>
> Hi
> Thanks for the reply I have taken on board what you mean about some of
> the labels used and will address this
>
> What I meant (I think) was this would require incorporating in a full
> stand alone script which would log into the db and do the required
> look and delete maybe on a daily basis
>
> I am sorry if it all sound a bit weird, as I am a novice a this with
> just some basic skills in this area
> Again thanks for the reply a least now I know it might work
> trawets
>
>
It's not hard. The script would be very similar to what you have for a
website, except it wouldn't echo, print, etc. anything. Rather any
messages would be written to a log file.
Start it out daily as a cron job (Linux) or scheduled task (Windows) and
let it go.
Nothing really special about it at all.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|