\n";
$content .= "\n";
$content .= "| "._WP_PROJECTNAME." | \n";
$content .= ""._WP_REPORTS." | \n";
$content .= ""._WP_LASTSUBMISSION." | \n";
$content .= "
\n";
$projectresult = $db->sql_query("SELECT project_id FROM ".$prefix."_nsnwb_projects WHERE featured='1' ORDER BY project_name");
while (list($project_id) = $db->sql_fetchrow($projectresult)) {
$project = wpproject_info($project_id);
$wpimage = wpimage2("project.png", $modname);
$content .= "\n | \n".$project['project_name']." | \n";
$reportnumber = $db->sql_numrows($db->sql_query("SELECT report_id FROM ".$prefix."_nsnwp_reports WHERE project_id='$project_id'"));
$content .= "$reportnumber | \n";
$lastresult = $db->sql_query("SELECT date_submitted FROM ".$prefix."_nsnwp_reports WHERE project_id='$project_id' ORDER BY date_submitted DESC LIMIT 1");
if($db->sql_numrows($lastresult) == 0){
$date_submitted = _WP_NA;
} else {
list($date_submitted) = $db->sql_fetchrow($lastresult);
$date_submitted = date($wp_config['report_date_format'], $date_submitted);
}
$content .= "$date_submitted | \n
\n";
}
$content .= "\n";
?>