/* Performing SQL query */
$nquery = "SELECT
MT_BLOGGERS.blog_name AS STUDENT,
blog_site_url,
MT_BLOG.blog_name,
COUNT( * ) AS COMPLETE,
ROUND(( DAYOFYEAR( CURDATE( ) ) - DAYOFYEAR( '2005-10-1' ) ) / 7,0) AS ASSIGNED,
ROUND(CASE
WHEN 100 * COUNT( * ) / ( ( DAYOFYEAR( CURDATE( ) ) - DAYOFYEAR( '2006-10-1' ) ) / 7 ) >= 100 THEN 100
ELSE 100 * COUNT( * ) / ( ( DAYOFYEAR( CURDATE( ) ) - DAYOFYEAR( '2006-10-1' ) ) / 7 )
END,0) AS SCORE,
blog_lastname
FROM
cics2005_mt.mt_blog MT_BLOG,
cics2005_mt.mt_bloggers2007 MT_BLOGGERS,
cics2005_mt.mt_entry MT_ENTRY
WHERE
MT_BLOG.blog_id = MT_BLOGGERS.blog_id
AND MT_BLOGGERS.blog_id = MT_ENTRY.entry_blog_id
AND ( entry_status = 2
AND MT_BLOGGERS.blog_id NOT IN( 40, 42, 51, 52, 56 )
AND LENGTH( entry_text ) > 150)

GROUP BY
MT_BLOGGERS.blog_name,
blog_site_url,
MT_BLOG.blog_name,
blog_lastname
ORDER BY
7";
$nresult = mysql_query($nquery) or die("Query failed : " . mysql_error());

/* Printing results in HTML */
echo "<table id=\"dataview\" cellspacing=\"0\">\n";
echo "\t<tr>\n";
echo "\t\t<td><strong>Weblog</strong></td>\n";
echo "\t\t<td></td>\n";
echo "\t\t<td><strong>Author</strong></td>\n";
echo "\t\t<td><strong>Entries</strong></td>\n";
echo "\t\t<td><div align=\"right\"><strong>Score</strong></div></td>\n";
echo "\t</tr>\n";
while ($line = mysql_fetch_array($nresult)) {
echo "\t<tr>\n";
echo "\t\t<td><a href=\"$line[1]\" alt=\"$line[0]\" title=\"$line[0]\">$line[0]</a></td>\n";
echo "\t\t<td>&nbsp;&nbsp;&nbsp;</td>\n";
echo "\t\t<td>$line[2]</td>\n";
echo "\t\t<td><div align=\"right\">$line[3]</div></td>\n";
echo "\t\t<td><div align=\"right\">$line[5]%</div></td>\n";
echo "\t</tr>\n";
}
echo "</table>\n";