how to fetch many rows from mysql

[Lionel]

Could someone please help fix the below? It is returning only one row. Thank you

PHP Code:

// ####################################################################### 
// ######################## START MAIN SCRIPT ############################ 
// ####################################################################### 

$postinfos = $DB_site->query("SELECT * FROM post WHERE award=1 and visible=1 ORDER BY dateline DESC");
$award = array();
while ($postinfo = $DB_site->fetch_array($postinfos))
{
exec_switch_bg();

$postid = $postinfo['postid'];
$tid = $postinfo['threadid'];
$uid = $postinfo['userid'];
$date = $postinfo['dateline'];
$username = $postinfo['username'];
$title = $postinfo['title'];    
mysql_free_result($postinfos);
}

$threads = $DB_site->query("SELECT * FROM thread WHERE threadid=$tid");
$threadid = array();
while ($threadinfo = $DB_site->fetch_array($threads))
{
exec_switch_bg();
$ttitle = $threadinfo['title'];
$forums = $threadinfo['forumid'];
mysql_free_result($threads);
}
$theforums = $DB_site->query("SELECT * FROM forum WHERE forumid=$forums");
$forumid = array();
while ($foruminfo = $DB_site->fetch_array($theforums))
{
exec_switch_bg();
$forum = $foruminfo['title'];
mysql_free_result($theforums);
}
construct_forum_jump(); 
$navbits = array(); 
$navbits[$parent] = 'Editor\'s Pick'; 

$navbits = construct_navbits($navbits); 
eval('$navbar = "' . fetch_template('navbar') . '";');

eval('print_output("' . fetch_template('pick') . '");'); 


[Velocd]

Mind explaining what you are trying to do?

As a general reminder on the forums, remember to post more specific details of your problem for a large chuck of code before assuming members will just instantly clue in. (especially when the code chunk isn't indented or formatted properly for readability)

[Lionel]

I am trying to fetch the users who receives an award (from the awards hack) to display the post name in a different page, with a link to that awarded post, the user and his id, the thread name and the linked forum

[Lionel]

here is an image of what I am desperately trying to achieve here and then click on thumbnail

[Colin F]

Just glancing over your script, you're missing calling any template.

You'll have to call a template with .= for each run through you make while fetching the array. That'll add the new data to the variable. Then, insert the variable in the main template.

Make sure you have both templates set up

[Lionel]

thanks for replying. Coincidentally I finally got it 5 minutes ago by altering another hack.