alex905
12-16-2006, 06:43 PM
i made a little script and it exercutes this query
SELECT title, threadid FROM `thread` WHERE forumid = '10' ORDER BY threadid LIMIT 300 , 10
the 300 is the variable.
when i run this and i check the posts it sometimes gets posts from other forums. i have moved most of the posts from other forums to the forumid 10 so im guessing is going to the original posts. but whay and how can i fix this.
i think a breif explaintion of theis query might help.
it is made to list 10 iteams stating at what theoird id i select form the forum with the id 10. if that makes sense. :rolleyes:
SELECT title, threadid FROM `thread` WHERE forumid = '10' ORDER BY threadid LIMIT 300 , 10
the 300 is the variable.
when i run this and i check the posts it sometimes gets posts from other forums. i have moved most of the posts from other forums to the forumid 10 so im guessing is going to the original posts. but whay and how can i fix this.
i think a breif explaintion of theis query might help.
it is made to list 10 iteams stating at what theoird id i select form the forum with the id 10. if that makes sense. :rolleyes: