|
|
| |
| Welcome to our motorcycle bike review section. Feel free to rate and review any motorcycle - let us have your views.
We are using the forum database as a means of registering reviewers. This does not imply that you need to use the forum or become a member
as such. Similarly forums members who want to review and rate can use the same logon.
We require this registration because we believe that the reviews and ratings should be credible, that one person should rate a Bike
only once and that reviewers should be bona-fide users of the Bikes.
Please register here.
|
| |
Bike Review Models '.$sCategoryName.''; ?>
3){echo ' ' ; $iSpan=1;}
$isubCategoryID= "$DOC->subcat";
$ssubCategoryName= "$DOC->subcatname";
echo '
'.$ssubCategoryName.' ';
$querycnt = "SELECT COUNT(Item) AS numrows FROM brrev WHERE category =".$iCategoryID." and subcat =".$isubCategoryID." and active";
$resultant = mysql_query($querycnt) or die('Error!!!!!!, query failed 2');
$rowing = mysql_fetch_array($resultant, MYSQL_ASSOC);
$iRecordcount = $rowing['numrows'];
if ($iRecordcount > 0) {
echo '(';
echo $iRecordcount;
echo ' reviews) '; }
echo '
';
if ($BlnShowCategoryDescriptions=1)
{echo $sCategoryDescription;};
echo ' | ';
}
?>
| |
Latest '.$sCategoryName.' reviews
';?>
';
' | ';
' <<Home -- <%=sCategoryName%>';
' | There are currently no external links listed. | ';}
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 brcat 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 '
|
 | Contributors 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 brrat 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 brurev 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 ' |
'; ?>
';
}
}
?>
