1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
|
$crew = $db->query ("SELECT
bb".$n."_threads.boardid,
bb".$n."_threads.location,
bb".$n."_threads.topic,
bb".$n."_threads.size,
bb".$n."_threads.crewid,
bb".$n."_threads.starterid,
bb".$n."_threads.threadid,
bb".$n."_threads.starter,
bb".$n."_threads.starterid,
bb".$n."_boards.title
FROM bb".$n."_threads
LEFT JOIN bb".$n."_users ON (bb".$n."_users.userid=bb".$n."_threads.lastposterid)
LEFT JOIN bb".$n."_boards ON (bb".$n."_boards.boardid=bb".$n."_threads.boardid)
ORDER BY bb".$n."_threads.starttime DESC LIMIT 5"); |