How to show total postcards in the statistics

[jamstave]

Hi..I want show total postcards(from gallery stated) in the site statistics?
Using "postcard_id"

gallery/postcards.php?postcard_id=4707

I tried this code in the "stats.php" but it's doesn't work please someone help me.

Code: [Select]

//-----------------------------------------------------
//--- Total Postcards ----------------------------------------
//-----------------------------------------------------
   $sql = "SELECT COUNT(*) as postcards
          FROM ".POSTCARDS_TABLE;
  $row = $site_db->query_firstrow($sql);

   
  $total_postcard = "".$lang['total_postcard']."<B> ".$row['postcards']."</B>\n";
 
  $site_template->register_vars("total_postcard", $total_postcard);
unset($total_postcard);
Jamestave.

[V@no]

what exactly doesnt work?

[jamstave]

what exactly doesnt work?

Hi...V@no thanks for your reply and it's show the current postcard in the database but i need total postcard since the gallery stated.

It's show this
Current postcard: 97

But i need to show this

Total Postcard: 4707

I need to get the last postcard id from the database.

gallery/postcards.php?postcard_id=4707

Jamestve.