PHP Forum

**lajkonik86** · 06-15-2005, 12:20 PM

Trying to show the latest threads the user started and the latest threads a user posted in.
I'm having 2 problems
- Don't show threads the user has started under threads a user posted in
- If a user has multiple post in one threads don't show thread multiple times

PHP Code:


			
//Mythreads Latest you started

$Recordset1 = mysql_query("SELECT * FROM `phpbb_topics` WHERE `topic_poster` = 2 ORDER BY `topic_time` DESC LIMIT 0 , 4") or die(mysql_error());

        $totalRows_Recordset1 = mysql_num_rows($Recordset1);

        $blue = 0;

        while ($results = mysql_fetch_array($Recordset1)) 

                    {

                                $id[$blue] = $results[topic_id];

                             $title[$blue] = $results[topic_title];

                             $blue++;                

                             if ($blue == 5) break;

                    }

echo "Threads you started:<br>";

$blue = 0;

while ($blue < 4) {

echo "<a href=\"http://www.top-download.net/forum/viewtopic.php?t=$id[$blue]\">$title[$blue]</a><br>";

$blue++;

}



//Mythreads Latest you posted in

$Recordset1 = mysql_query("SELECT * FROM `phpbb_posts` WHERE `poster_id` = 2 ORDER BY `post_time` DESC LIMIT 0 , 4") or die(mysql_error());

        $totalRows_Recordset1 = mysql_num_rows($Recordset1);

        $blue = 0;

        while ($results = mysql_fetch_array($Recordset1)) 

                    {

                                $id[$blue] = $results[topic_id];

                             $title[$blue] = $results[topic_title];

                             $blue++;                

                             if ($blue == 5) break;

                    }

echo "Topics you posted in:<br>";

$blue = 0;

while ($blue < 4) {

echo "<a href=\"http://www.top-download.net/forum/viewtopic.php?t=$id[$blue]\">topic$blue</a><br>";

$blue++;

}

Help is greately appreciated

**lajkonik86** · 06-17-2005, 06:26 AM

Fixed the duplicate
Now trying to exclude the threads a user started:
$id is an array, naturally this code doesn't work. How do i tell it to exclude all values in the array id??

$Recordset1 = mysql_query("SELECT DISTINCT `topic_id`
FROM `phpbb_posts`
WHERE `poster_id` =2
AND `topic_id` != '$id'
ORDER BY `post_time` DESC
LIMIT 0 , 4") or die(mysql_error());

**lajkonik86** · 06-17-2005, 11:02 AM

Fixed problem of duplicated and added name of post query.
One problem left

PHP Code:


			
//Mythreads Latest you posted in

$Recordset2 = mysql_query("SELECT DISTINCT `topic_id` FROM `phpbb_posts` WHERE `poster_id` =2

AND `topic_id` != '$id' ORDER BY `post_time` DESC LIMIT 0 , 4") or die(mysql_error());

$blue = 0;

while ($results = mysql_fetch_array($Recordset2)) 

                    {



                                $id[$blue] = $results[topic_id];

                             $title[$blue] = $results[topic_title];

                             $blue++;        

                             if ($blue == 5) break;

                    }

$Recordset2 = mysql_query("SELECT * FROM `phpbb_topics`") or die(mysql_error());

while ($results = mysql_fetch_array($Recordset2)) 

                    {



                             $names["$results[topic_id]"] = $results[topic_title];

                    }