Help with Cron Setup

[The_broken]

Ok, I have a script that uses session/Ips to track all users using orders system.

need to do:

Clear a database table hourly using cron job

database: mysql
database name: My_billing

database host: localhost
database user: me
database password: test
database table to clear:sessions

what i need: I am lost 😕

a complete command line to put in the text box of the cpanel.

How can I setup so that it will delete the sessions that are stored in the DB every Hour.

Thanks
The_broken

[mattsinclair]

create a php script to do the job, and add a cronjob for the php script

[The_broken]

ok, that would work, but I am not good at PHP Is there a script already online that I can get.

[TheIceman5]

Originally posted by The_broken
ok, that would work, but I am not good at PHP Is there a script already online that I can get.

u seem like a noob of noobs, just search the forum.

need one sql line DELETE * FROM table

just SEARCH, youll find connection strings, very very easy, this brings back memories as when i was first writing my first database connectivity code, I SEARCHED!!!