| " . $review_1;
$html .= " | ";
echo whattable("100%","center","",$html);
unset($html);
$get_site = sql_query("
select
*
from
$tb_links
where
ID = '$SiteID'
");
$site_rows = sql_fetch_array($get_site);
$average = sql_query("
select
avg(Rating) as average
from
$tb_reviews
where
SiteID = '$SiteID'
and
Status = 'Show'
");
$av_rows = sql_fetch_array($average);
$html = $table2 . "| ";
$html .= $review_2 . " " . $site_rows["SiteName"] . "";
if(isset($av_rows["average"])){
$html .= " - " . $review_3 . "";
$html .= $av_rows["average"] . "";
}
$html .= " |
";
$get_reviews = sql_query("
select
*
from
$tb_reviews
where
SiteID='$SiteID'
and
Status='Show'
order by
Added desc
limit
0,10
");
if(sql_num_rows($get_reviews)>0){
$html .= "
";
while($rows = sql_fetch_array($get_reviews)){
$html .= "- " . $rows[ReviewTitle];
$html .= " - " . $rows[Review] . "
" . $review_4;
$html .= $rows[Reviewer] . " - <";
$secure_email = str_replace("@", $review_5, $rows[ReviewerEmail]);
$secure_email = str_replace(".", $review_6, $secure_email);
$secure_email = str_replace("-", $review_7, $secure_email);
$secure_email = str_replace("_", $review_8, $secure_email);
$html .= $secure_email . ">";
if(strlen($rows[ReviewerURL])>0){
$html .= " of " . $rows[ReviewerURL] . "";
}
$html .= " ";
}
$html .= " |
";
} else {
$html = $table2 . "" . $review_9;
$html .= "
|
";
}
echo table("98%","center","",$html);
unset($html);
$html = $table2 . "| " . $review_10;
$html .= " |
";
echo table("98%","center","",$html);
unset($html);
?>