$a1[ItemTitle]

"; $q1 = "select ItemID, sum(Rating) as mr from dd_rating group by ItemID order by mr desc limit 0,9"; $r1 = mysql_query($q1) or die(mysql_error()); while($a1 = mysql_fetch_array($r1)) { $q2 = "select ItemTitle from dd_items where ItemID = '$a1[0]' "; $r2 = mysql_query($q2) or die(mysql_error()); while($a2 = mysql_fetch_array($r2)) { $Top_10 .= "$a2[0]
\n"; } } $q1 = "select * from dd_items where ItemStatus = 'approved' order by DateAdded desc limit 0,9"; $r1 = mysql_query($q1) or die(mysql_error()); while($a1 = mysql_fetch_array($r1)) { $Newest .= "$a1[ItemTitle]
\n"; } require_once("templates/MainHeader.html"); require_once("templates/MainIndex.html"); require_once("templates/MainFooter.html"); ?>