Topic: new user psot list and message link to

Well, i managed to get a new post on my front page, but how can i get this type of message

@subject@ posted by @user@

?

Thanx, in advance

Re: new user psot list and message link to

Moved to Troubleshooting

Re: new user psot list and message link to

something like this?


http://bunpai.com/2.php


Q

My stuff or my style might sux, but atleast I'm willing to help when I can.
Don't be stupid and help ! We are the stupid one's !!!

Re: new user psot list and message link to

<?php $cur_topic['subject'] ?> Posted by <?php $cur_post['message'] ?>

i think

Sorry. Unactive due to personal life.

Re: new user psot list and message link to

yeah
but i need to have something from mysql dbase?

6 (edited by duasun 2007-08-21 11:25)

Re: new user psot list and message link to

MAybe i didnt asked right question

Q is:

What mysql query i need to use to get array of 10 last posts with poster?


at this time i'm using this:

$query1 = "select subject,id from ".$db_prefix."topics order by last_post desc limit 10;";

Re: new user psot list and message link to

duasun wrote:

yeah
but i need to have something from mysql dbase?

shouldnt think so, they were alrdy in the "miniportal" code so if your using that it should be fine.

if not, add

t.poster, t.subject,

to the mysql qurey

Sorry. Unactive due to personal life.