Is there any system to count database hits.

I have a webdirectory.

I want to show statistics like this:

Total 45 database hits, 500 websites under 30 category.

I can count websites & category.

But how I can count database hits

pls. help me

Best Regard:
Md. Zakir Hossain (Raju)
www.rubd.net
www.xenex.rubd.net
www.forum.rubd.net

__________________
Best Regard:
Md. Zakir Hossain (Raju)

www.rajuru.xenexbd.com - my blog with PHP scripts, PHP Book Review and many more

Sure, you can count database hits. At some point after a database has been queried, add something like this.

UPDATE `table_name` SET `hit_counter` = `hit_counter` + 1 WHERE `condition` = 1;

With this you've added an integer field to the table you want to count hits on and are incrementing that field by one each time it is accessed.

HTH!

Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail