Hi <br /> <br />First thing I want to do is integrate the forusm so we can post a "latest posts" list on the general site. But we use ASP there. <br /> <br />Can anyone tell me which fields, in which tables, PHP quesries to get the latest posts? Useful fields would be those defining the latest-post-date in a thread, as well as the thread topic, board name (since there are several boards). <br /> <br />Bascially this is what I want: <br /> <br />1. Post a list of the ten latest posts on the entire forum, using ASP, and post the thread names and fourms they are from. <br /> <br />2. Post such a list, but board-specific, ie the ten latest posts from a board. <br /> <br />Thanks! <br />James

Posts are stored in w3t_Posts. I have never worked with ASP pages but in one of my php scripts I use these fields to basicly do what you are wanting to do: <br />B_Number,B_Posted,B_Last_Post,B_Username,B_Subject,B_Body,B_Main,B_Replies,B_Board,B_File,B_Poll,B_Status <br /> <br />The forum name is not stored in this table but the forum's keyword is. You will have to pull the forum's title from w3t_Boards in the field Bo_Title <br /> <br />You may want to take a look at the ubbtnews.php script located in your "addons" directory. This should help []/forum/images/icons/smile.gif[/]