Thanks D-O, this is harder than i remember. The motd.top10.php is now showing nicely in the MOTD, HOWEVER the boxes are not populated.

I noticed you said you have another file which actually grabs the DB entries. how would i go about generating this other file?.

Thanks for your time and patience.

Ba5ic

everytime the motd_query.php is called, it will get the top 10 from the db and save them to the motd_saved.php

I have my stats update every hour, so i have a cron setup calling the motd_query.php file at 15 minutes after every hour.
(for my web server it looks like: php -q /home/user/public_html/avamods/stats/motd_query.php)

This method saves a ton of db queries. As you dont need to get the top10 from the db everytime the motd (or whatever youre using the top10 in) is called when there hasnt been any update to the stats. Its also much faster on a huge/slow stats db

Thanks D-O, Ur a star !!! :P

Only problem, my cronjob won't run, don't know if its because its in the public_html folder?, all permissions are correct. May try putting the motd_query.php next to the stats.pl, i know that runs and updates the stats.

I ran the motd_query.php just by navigating to the page --> MOTD Top Ten Updated Successfully. At least top10 are showing now :P.

Thanks again.