Page Hits On Admin Page

[gaspower]

Hello,

 

I am using the below code on my admin page for customer count and product count, but I want to add site page hits from counter. For some reason everything I try breaks the page. Any help on how to add to my code would be greatly appreciated. Just need to add counter hits,

 

<?php

$customers_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS);

$customers = tep_db_fetch_array($customers_query);

 

$products_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'");

$products = tep_db_fetch_array($products_query);

 

echo $customers['count'] . ' ' . CUSTOMERS . '<br>' . $products['count'] . ' ' . PRODUCTS . '<br>';

?>

 

Thanks JR

[♥geoffreywalton]

and what is the error you get?

[gaspower]

Hello,

 

When I add this,

 

$counter_query = tep_db_query("select counter from " . TABLE_COUNTER);

 

I get this error,

 

1146 - Table 'website.TABLE_COUNTER' doesn't exist

 

select counter from TABLE_COUNTER

 

But Table_counter does exits in the database?

 

Thank you JR

[germ]

  define('TABLE_COUNTER', 'counter');

Add to /admin/includes/database_tables.php

[gaspower]

Hello Jim,

 

Thank you, no error now.

 

Thanks JR