<?php
$grab_sql = @mysql_query($query);
if(@mysql_num_rows($grab_sql) > 0) { // IF RECORDS

if ($section != "") {
	/*
?>
<img src="images/section_<?=$section?>.jpg" width="360" height="54" /><br />
<?
*/
if (isset($quicksort)) {
?>
<table border="0" cellspacing="10" cellpadding="0">
  <tr>
  <td><div align="right" class="heading">Quick Sort</div></td>
      <?
  if($sort_by == "name") {
		echo "<td><span class=\"contentname\">alphabetical</span></td><td width=\"1\">-</td>";
	} else {
		echo "<td><a href=\"videos.php?sort_by=name&sort_order=ASC\">alphabetical</a></td><td width=\"1\">-</td>";
	}

  if($sort_by == "rate") {
		echo "<td><span class=\"contentname\">top rated</span></td><td width=\"1\">-</td>";
	} else {
		echo "<td><a href=\"videos.php\">top rated</a></td><td width=\"1\">-</td>";
	}

  if($sort_by == "releasedate") {
		echo "<td><span class=\"contentname\">newest releases</span></td>";
	} else {
		echo "<td><a href=\"videos.php?sort_by=releasedate&sort_order=DESC\">newest releases</a></td>";
	}
	?>

  </tr>
</table>
<?
}

}
    $section = "index";
?>
<?=$pagination?><br />
<table border="0" cellspacing="10" cellpadding="0" <?php if($section == 'index') { ?>width="100%;" class="index-updates"<?php } else { ?>width="660"<?php } ?>>
<?
$step_count = 0;
$total_count = 0;
unset($row);
if ($_SERVER['PHP_SELF'] == "/members/mystuff_favorites.php") {
	$show_fav = 1;
} else {
	$show_fav = 0;
}

while ($row = mysql_fetch_array($grab_sql)) {
	if ($step_count == 0) { echo "<tr>"; }

	// FAV PAGE ONLY
	$fav_html = "";
	if ($show_fav == 1) {
		$fav_html = "<tr><td align=\"center\" height=\"20\" colspan=\"2\"><div id=\"fav_".$row['content_id']."\"><a href=\"javascript:fav('2','0','".$row['content_id']."','0','0')\"><img class=\"no-resize\" src=\"images/favorite_rem.jpg\" width=\"131\" height=\"18\" border=\"0\" /></a></div></td></tr>";
	}
	// FAV PAGE ONLY

		$icon = $contentweb.$row['content_id']."_icon.jpg";
//$icon = $contentweb."video_icon.jpg";

		$rd = explode('-',$row['releasedate']);
		//$releasedate = date("F j, Y",mktime(0,0,0,$rd[1],$rd[2],$rd[0]));
		$releasedate = $rd[1]."-".$rd[2]."-".$rd[0];

		if ($row['rate'] == "") { $rate = "0.00"; } else { $rate = $row['rate']; }

		$rate = round($rate,2);

		$models = "";

		$get_models = @mysql_query("SELECT `cms_models`.`model_id`, `cms_models`.`name`
		FROM `cms_content_models`
		INNER JOIN `cms_models` ON `cms_models`.`model_id` = `cms_content_models`.`model_id`
		WHERE `cms_content_models`.`content_id` = '".$row['content_id']."' ORDER BY `cms_models`.`name` ASC");

		while ($mod = mysql_fetch_array($get_models)) {
			$models .= " <a href=\"model.php?id=".$mod['model_id']."\">".stripslashes($mod['name'])."</a>,";
		}
			$models = rtrim($models, ',');

		if ($row['releasedate'] <= $today) {
			$url = "video.php?id=".$row['content_id'];
		} else {
			$url = "#";
		}

		$isexclusive = @mysql_query("SELECT `cms_tags`.`content_id` FROM `cms_tags` WHERE `cms_tags`.`content_id` = '".$row['content_id']."' AND `cms_tags`.`content_type` = '3' AND `cms_tags`.`stag_id` = '321' ");
		if(@mysql_num_rows($isexclusive) > 0) {
			$isexclusive = 1;
		} else {
			$isexclusive = 0;
		}

?>
<td valign="top" width="<?php if($section == 'index') { ?>33%;<?php } else { ?>220<?php } ?>">
<table border="0" cellpadding="0" cellspacing="0" width="<?php if($section == 'index') { ?>100%;<?php } else { ?>200<?php } ?>">
<?=$fav_html?>
<tr>
<td valign="top"><? if ($row['releasedate'] > $today) { echo "coming soon! "; } ?><strong><?=$releasedate?></strong></td>
<td align="right">
<?
if ($row['releasedate'] <= $today) {
?>
<strong><?=$rate?></strong> rating
<?
}
?></td>
</tr>
<tr>
<td colspan="2">
<a href="<?=$url?>"><img src="<?=$icon?>" border="0" class="tn" /></a><br />
<strong><?=stripslashes($row['name'])?></strong><br /><br />
<strong>featuring:</strong> <?=$models?>
</div>
</td></tr></table>
</td>
<?
$step_count++;
$total_count++;

	if($step_count == $num_columns) {
	$step_count = 0;
	echo "</tr>";
	}

}
if ($total_count < $num_columns) {
for ($i=$step_count;$i<$num_columns;$i++) {
echo "<td valign=\"top\" width=\"220\">&nbsp;</td>";
}
echo "</tr>";
}
?>

</table>
<?
echo $pagination."<br />";
}
?>