include table title

[distinct]

Hello

I am modifying someone else's code, and having the following problem.

Code:

$result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster, f.forum_assoc FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE fp.read_forum IS NULL OR fp.read_forum=1 ORDER BY c.disp_position, c.id, f.disp_position', true) or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());

f.last_post_id refers to the id of an entry in the table posts. The entry in the table post contains the topic id, which contains the topic title.

Does anyone have any idea as to how I can modify this query to include the topic title? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[techguru]

Couldn't understood you fully, but i think this is what you want

select c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, ( select title from posts where topic_id = f.last_post_id ) as topic_title , f.last_poster, f.forum_assoc from '.$db->prefix.'categories AS c inner join '.$db->prefix.'forums AS f on c.id=f.cat_id left join '.$db->prefix.'forum_perms AS fp on (fp.forum_id=f.id and fp.group_id='.$pun_user['g_id'].') where fp.read_forum is null or fp.read_forum=1 order by c.disp_position, c.id, f.disp_position

Bye -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[owais]

posting the same code as techgure but in more readable form, see for yourself


select c.id AS cid
, c.cat_name
, f.id AS fid
, f.forum_name
, f.forum_desc
, f.redirect_url
, f.moderators
, f.num_topics
, f.num_posts
, f.last_post
, f.last_post_id
, ( select title
from posts
where topic_id
= f.last_post_id ) as topic_title
, f.last_poster
, f.forum_assoc
from '.$db->prefix.'categories AS c
inner
join '.$db->prefix.'forums AS f
on c.id=f.cat_id
left
join '.$db->prefix.'forum_perms AS fp
on (fp.forum_id=f.id
and fp.group_id='.$pun_user['g_id'].')
where fp.read_forum is null
or fp.read_forum=1
order
by c.disp_position
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --