Shoutbox

quote:

---

Originally posted by RaceProUK
Actually, quick question: why is fid a text field when you're storing numbers in it?

---

I'm not, it's in MyBB post's table, I'm taking the id from it to show the latest posts on my forums. Some forums are hidden so I'm using all those numbers to display the forum ids I want. I then process the data like this :

code:

---

$result = mysql_query("select *from posts where fid in ('2','8','4','5','6','9','22','24','14','23','11','12','13') order by dateline desc limit 5");
while($r = mysql_fetch_array($result))
{
    $pid = $r['pid'];
    $tid = $r['tid'];
    $subject = $r['subject'];
   
    echo "<a href=\"http://forum.msgstuff.com/showthread.php?tid=$tid&pid=$pid\" target=\"_blank\">$subject</a>\n";
}

---