What's wrong with this query?

[Akex]

Ok I gave the request above as I saw you put LIMIT 10 and didn't put a coherent where clause.

What do you want exactly. A number of posts ?

PHP Code:

$getnewposts = $DB_site->query_first("SELECT count(*) as count FROM " . TABLE_PREFIX . "post as p
LEFT JOIN " . TABLE_PREFIX . "thread as t ON (t.threadid = p.threadid)
WHERE t.forumid = 13 ORDER BY p.dateline DESC LIMIT 10"); 


It's better but, this request will give you the last 10 posts in forumid 13. You must give in the where clause a dateline condition. LIMIT 10 is useless unless you want to display at least 10 last posts and no more

PHP Code:

WHERE t.forumid = 13 AND p.dateline > $bbuserinfo[lastvisit] 


[Deaths]

Yes, I want the number of new posts (as a number) from a certain forum (13).

With that code $newposts returns 10, while there are no posts at all...

[Akex]

That what I said . How do you want number of newpost to be return has you didn't put any dateline condition in the query ?

Replace this in the query :

PHP Code:

WHERE t.forumid = 13 


By the last code I gave in post #11

[Deaths]

It works now, thanks!

Silly me, I forgot about the dateline condition ^^