Hejsa
jeg har denne som finder de nyeste indlæg i min database..
Men jeg ønsker kun at der vises 1 indlæg fra hvert U_Number, hvordan gør jeg
det ??
SELECT w3t_Boards.Bo_Title, w3t_Posts.B_Number, w3t_Posts.B_Posted,
w3t_Posts.B_Last_Post, w3t_Users.U_Username, w3t_Posts.B_Subject,
w3t_Posts.B_Body, w3t_Posts.B_Main, w3t_Posts.B_Replies,
w3t_Posts.B_Counter, w3t_Posts.B_Board
FROM w3t_Posts, w3t_Boards, w3t_Users
WHERE B_Number = B_Main
AND w3t_Users.U_Number = w3t_Posts.B_PosterID
AND w3t_Posts.B_Posted > '$date'
AND w3t_Posts.B_Board = '$myBoard'
AND w3t_Boards.Bo_Keyword = '$myBoard'
AND w3t_Users.venus = 'ja'
ORDER BY RAND()
thomas
|