Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FUNCTION getUniquePosts($num = 10, $db) {
- $postarr = array();
- $skip = array();
- FOR($i = 0; $i < $num; $i++) {
- $sql = "SELECT p.ID as ID, p.Date as Date, p.Thread as Thread, t.Subject as Subject from unb_posts AS p, unb_threads AS t where (p.Thread=t.ID)";
- IF(COUNT($skip)) {
- foreach($skip AS $tid) {
- $sql .= "AND (p.Thread != ".$tid.") ";
- }
- }
- $sql .=" ORDER BY p.Date DESC limit 1";
- // okay, do query
- $res = mysql_query($sql, $db);
- $row = mysql_fetch_assoc($res);
- $postarr[] = $row;
- $skip[] = $row['Thread'];
- }
- RETURN $postarr;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement