link of questions

Anonymous · Jan 25, 2006

hi
i want to put the nwest questions of my forum in index of my site as link to forum
how can i do it?
thanks

gesf · Jan 25, 2006

Just query your forum posts table:

Code:

SEL... whatever, whatever FROM forum_table ORDER BY post_date DESC LIMIT 0,5;

Something like this. Will get the latest 5 posts.

Anonymous · Jan 26, 2006

thanks for your reply
but how can i put this link in one table? .inex of my site was writen by html and it has som table like the first page of yahoo

Anonymous · Jan 26, 2006

you should use php, then write:

Code:

<a href="youforumpage.php?fid=number"><?php echo "here echo your last 5 or 10 posts' headers form your table"; ?></a>

fid: refers to forum id;

gesf · Jan 29, 2006

Like adly3000 wanted to show, after that, you need to make the proper output (html obviously).