Hello!
I want to run a direct SQL command daily, and at first I thought I would set up a CRON job in conjunction with the daily build job... then I thought I might just put the SQL command right into nph-build.cgi
So...... how do I write a command in there to run an SQL command (or am I all wrong asbout doing this anyway???)
I want to run:
Update Links set Hits = '0' where CategoryID = 50
TIA!
Dave
I want to run a direct SQL command daily, and at first I thought I would set up a CRON job in conjunction with the daily build job... then I thought I might just put the SQL command right into nph-build.cgi
So...... how do I write a command in there to run an SQL command (or am I all wrong asbout doing this anyway???)
I want to run:
Update Links set Hits = '0' where CategoryID = 50
TIA!
Dave