';}
Else
{
echo '';
$Result = mysql_query($sSQL);
$my_var = 0;
$mystr = 999999;
$sFeatured = "ZZZ";
$j = 0;
while ( $DOC = mysql_fetch_object( $Result )) {
$iLinkID="$DOC->primkey";
$sLinkName="$DOC->Item";
$iCategoryID="$DOC->category";
$iRating="$DOC->editorsrating";
$sLinkDescription="$DOC->summary";
$dDate_Added="$DOC->date";
$sURL="$DOC->URL";
$simage="$DOC->image";
$sSQLcat="SELECT * FROM prcat WHERE category = $iCategoryID ;";
$Resultcat = mysql_query($sSQLcat);
while ( $DOCcat = mysql_fetch_object( $Resultcat )) {
$sCategoryName = $DOCcat->catname;
} ?>
| '.$sLinkName.' | MSE Ratings | |
';
echo '
 | '.$sLinkDescription.'
';
echo '';
if ($suppress != "NR"){
echo '';
echo '
| ';
echo 'Read the full review
| ';
}
if ($DOC->Price < 0.01 ) { echo ' | '.$DOC->pricequal.' | '; }
else
{
echo ' | £'.$DOC->Price.' '.$DOC->pricequal.' | ';}
$dayear = substr($dDate_Added,0,4);
$damonth = substr($dDate_Added,5,2);
$daday = substr($dDate_Added,8,2);
$maydatets = mktime(0,0,0,$damonth,$daday,$dayear);
$maydate = date("jS F Y", $maydatets);
echo ' | ';
echo 'Date Added: '. $maydate.' |  |
Source: '.$sURL.' |  |
Rate this item |
 |
Review this item | ';
echo '
|
 | Editors rating:- '.$iRating.' | ';
$ir10 = $iRating * 10;
$counter = 1;
while ( $counter <= $ir10 ) {
if ($counter == 10 || $counter == 20 || $counter == 30 || $counter == 40){
echo ' ';}
else
{
echo ' ';}
$counter = $counter + 1;
}
echo ' | ';
// user rating
$iratcnt = 0;
$itotal = 0.0;
$query3 = "SELECT * FROM prrat WHERE itempk =".$iLinkID." ";
$result3 = mysql_query($query3) or die('Error!!!!!!, query failed');
while ( $DOC3 = mysql_fetch_object( $result3 )) {
$iratcnt = $iratcnt + 1;
$itotal = $itotal + $DOC3->rating;
}
$daverage = number_format ($itotal / $iratcnt , 2);
echo ' | ';
if ($iratcnt > 0){
echo 'Members rating:- '.$daverage.'';}
else {
echo 'No votes';}
echo ' | ';
$ir10 = $daverage * 10;
$counter = 1;
while ( $counter <= $ir10 ) {
if ($counter == 10 || $counter == 20 || $counter == 30 || $counter == 40){
echo ' ';}
else
{
echo ' ';}
$counter = $counter + 1;
}
echo ' | ';
if ($iratcnt > 0)
{ echo ' | From '.$iratcnt.' votes | | ';}
if ($iratcnt < 1)
{ echo '| Be the first to rate this item | ';}
$query4 = "SELECT * FROM prurev WHERE ID =".$iLinkID." ";
$iratcnt = 0;
$result4 = mysql_query($query4) or die('Error!!!!!!, query failed');
while ( $DOC4 = mysql_fetch_object( $result4 )) {
$iratcnt = $iratcnt + 1;
}
echo ' | Total member reviews | '.$iratcnt.' | ';
if ($iratcnt > 0)
{
if ($suppress != "NR"){
echo '| Read the full review | ';
}
}
else
{ echo '| Be the first to review this item | ';}
echo '
';
echo ' |
'; ?>
';
}
}
?>
';
}
echo '
<<Home