I used to have the last 10 posted replies on the index page and I remade it so it's in one of the custom Pall boxes and upgraded it from v5x to the new 6.2, however I am running into a little SQL question ?
I have following statement
Code
<br /> $query = "<br /> SELECT B_Number,B_Posted,B_Last_Post,B_Subject,B_Body,B_Main,B_Replies,B_Counter,B_Board,U_Username,Bo_Read_Perm<br /> FROM w3t_Posts, w3t_Users, w3t_Boards<br /> WHERE BO_Keyword = B_Board <br /> AND Bo_Read_Perm like $readperm<br /> AND B_PosterId = U_Number<br /> AND B_Posted > $date<br /> ORDER BY $sort DESC<br /> LIMIT $totalthreads<br /> ";<br />
However I only want to show the last reply of a topic if there are more than one reply that would make it to the above statement.
So basicly I want the highest B_Number for one given B_Main.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
