Forums

[Jake]

Hey, im having some trobules with forums. I don't really know how to print a users level, and amount of forum posts next to their reply.

This is what i currently have:

$ab=mysql_query("SELECT * FROM forumposts WHERE postTHREAD={$_GET['thread']} ORDER BY postID ASC",$c);
$a=mysql_fetch_array($ab);
$reply=mysql_query("SELECT * FROM users WHERE userid={$a['postUSERID']}",$c);
$reply1=mysql_fetch_array($reply);

 

And then this is the table where it prints it:

 

{$r['postUSERNAME']}

Level:{$reply1['level']}

Posts:{$reply1['forumposts']}

{$r['postTEXT']} ";

 

This prints one person's level and posts for every bodys response.

Somebody help please

[ThePlague]

Re: Forums

im not sure as i dont have forums but i would of thought itd be just userID and userLEVEL unless your sql field has postUSER n tht