[Andreas]

Originally Posted by SupaJ

it doesnt give me any date, is there any file i need to include for it?

That's more then strange, should definitly work.
Maybe you got a typo?

with the posts i mean a string on my site that changes everytime the post number changes, so i dont have to update it manually

The query I posted does that.
Do you need PHP-Code too?
So here we go:

PHP Code:

$posts = $DB_site->query_first("SELECT COUNT(*) AS total FROM " .  TABLE_PREFIX . "post"); 


And then use $posts[total] in your template.