the review site with a difference since 1999
Visit:
Zarabesque.com
Susti Heaven
Brand Perfect
Closet Nomad
Tiendaholics.com
Zarabesque.com
Susti Heaven
Brand Perfect
Closet Nomad
Tiendaholics.com
query($query);
if (!$result) die($connection->error);
$rows = $result->num_rows;
for ($i = 0; $i < $rows; ++$i)
{
$result->data_seek($i);
$row = $result->fetch_array(MYSQLI_ASSOC);
$ID = $row["ID"];
$title = $row["title"];
$secondtitle = $row["secondtitle"];
$status = $row["status"];
$studio = $row["studio"];
$subhead = substr($title,0,15);
$year = $row["year"];
$quote = $row["quote"];
$quoted = $row["quoted"];
$recommendation = $row["recommendation"];
$whatdate = $row["publishdate"];
$whatdate = strtotime($whatdate);
$whatdate = date("F j, Y, g:i a",$whatdate);
$cast = $row["cast"];
$director = $row["director"];
$mpaa = $row["mpaa"];
$ratingfor = $row["ratingfor"];
$runtime = $row["runtime"];
$thissrc = $row["source"];
$type = $row["type"];
$thisurl = $row["url"];
$releasedate = $row["releasedate"];
$genres = $row["genres"];
$genres = explode(",",$genres);
$moviegrade = $row["moviegrade"];
$dvdgrade = $row["dvdgrade"];
$blurb = $row["blurb"];
$blurb = nl2br($blurb);
$body = $row["body"];
$techinfo = $row["techinfo"];
$buyinfo = $row["buyinfo"];
$byline = $row["byline"];
$keywords = $row["keywords"];
$coverart = $row["coverart"];
$still = $row["still"];
$amazon = $row["amazon"];
$amazon = trim($amazon);
$upc = $row["upc"];
}
// get author info
$aquery = "SELECT first_name,last_name,ID FROM authors where ID=$byline";
$aresult = $connection->query($aquery);
$arows = $aresult->num_rows;
for ($k = 0; $k < $arows; ++$k)
{
$aresult->data_seek($k);
$arow = $aresult->fetch_array(MYSQLI_ASSOC);
$revlink = $arow["ID"];
$firstname = $arow["first_name"];
$lastname = $arow["last_name"];
$itemline = "$firstname $lastname $whatdate";
}
echo "
";
echo "";
echo "![](\"docons/aicon.gif\")
";
}elseif($eachtech[$n] == "W"){
echo "![](\"docons/wicon.gif\")
";
}elseif($eachtech[$n] == "K"){
echo "![](\"docons/kidicon.gif\")
";
}elseif($eachtech[$n] == "5.1"){
echo "![](\"docons/51icon.gif\")
";
}elseif($eachtech[$n] == "DTS"){
echo "![](\"docons/dtsicon.gif\")
";
}elseif($eachtech[$n] == "E"){
echo "![](\"docons/extraicon.gif\")
";
}elseif($eachtech[$n] == "HD"){
echo "![](\"docons/hdicon.gif\")
";
}elseif($eachtech[$n] == "BR"){
echo "![](\"docons/bluerayicon.gif\")
";
}else{
echo "";
}
$n++;
}
}
if($blurb != "") {
echo "$blurb
Movie Grade: $moviegrade
DVD Grade: $dvdgrade
$body"; } if($thissrc != ""){ echo ""; } echo"
";
}
?>
$secondtitle
";
echo "Studio: $studio
";
echo "Year: $year
";
echo "Cast: $cast
";
echo "Director: $director
";
echo "Release Date: $whatdate
";
echo "Rating: $mpaa for $ratingfor
";
echo "Run Time: $runtime
";
echo "
"; if($quote!=""){ echo "$quote - $quoted"; } echo "
"; if($status=="complete"){ if($coverart != ""){ echo "";
if($amazon !=""){
echo "";
}
echo "";
if($amazon !=""){
echo "";
}
if($amazon !=""){
echo "
Buy Now @ Amazon
";
}
if($amazon !=""){
echo "";
}
echo "";
if($amazon !=""){
echo "";
}
if($amazon !=""){
echo "
Buy Now @ Amazon
![\"\"](\"docons/recicon.gif\"){kind=small}
";
}elseif($eachtech[$n] == "W"){
echo " ";
}elseif($eachtech[$n] == "K"){
echo " ";
}elseif($eachtech[$n] == "5.1"){
echo " ";
}elseif($eachtech[$n] == "DTS"){
echo " ";
}elseif($eachtech[$n] == "E"){
echo " ";
}elseif($eachtech[$n] == "HD"){
echo " ";
}elseif($eachtech[$n] == "BR"){
echo " ";
}else{
echo "";
}
$n++;
}
}
if($blurb != "") {
echo "$blurbMovie Grade: $moviegrade
DVD Grade: $dvdgrade
$body"; } if($thissrc != ""){ echo ""; } echo"
"; echo $itemline; echo "
"; echo "