You are not logged in. Please login or register.
PunBB Forums → Programming → Problem with mysql request ... (call topics on a page)
SELECT * FROM `punBB_forums` INNER JOIN punBB_topics ON ( punBB_forums.id = punBB_topics.forum_id ) WHERE forum_id = 5 and closed = 1 ORDER BY punBB_topics.id DESC LIMIT 0 ,10
Look at my forum http://www.sortons.net/forum/viewforum.php?id=5
As you can see, this forum has only 2 non closed topics ... but the result = the 10 last posts, even if I choose "CLOSED=1" ... where is the problem ?
What results you need to get?, your sql get the last 10 closed topic added to forum 5.
The problem is I put closed=1 ou closed=0, I have the same results ...
The results I want is "I want only the "open posts" ... in this case, even if I put a limit of 10 posts, I would like only to have the 2 actuals posts "non closed".
Try it im not test it 
SELECT * FROM `punBB_forums`
INNER JOIN punBB_topics ON ( punBB_forums.id = punBB_topics.forum_id and punBB_topics.closed = 0)
WHERE forum_id = 5
ORDER BY punBB_topics.id DESC LIMIT 0 ,10Thanx ! 
works like a charm
Another question (I begin ...) where include " AND punBB_topics.closed = 0 " inside extern.php ?
PunBB Forums → Programming → Problem with mysql request ... (call topics on a page)
Powered by PunBB, supported by Informer Technologies, Inc.