<?php
$grab_sql = @mysql_query($query);
if(@mysql_num_rows($grab_sql) > 0) {
	/*
?>
<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=\"models.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=\"models.php\">top rated</a></td><td width=\"1\"></td>";
	}
	
  if($sort_by == "releasedate") {
		echo "<td><span class=\"contentname\">recent</span></td>";
	} else {
		echo "<td><a href=\"models.php?sort_by=releasedate&sort_order=DESC\">recent</a></td>";
	}
	
	?>
  
  </tr>
</table>
<?
}

if(!isset($delights)) {
	$letter_nav = "<div class=\"pagination\" style=\"padding:20px;\" align=\"right\">";
	$get_letters = @mysql_query("SELECT LEFT(`cms_models`.`name`,1) as model_letter FROM `cms_models` WHERE `cms_models`.`releasedate` <= '".$today."' GROUP BY model_letter ORDER BY model_letter");
	while ($letter = mysql_fetch_array($get_letters)) {	
		if($_GET['letter'] == $letter['model_letter']) {
			$letter_nav .= "<a href=\"#\" class=\"currentpage\">" . $letter['model_letter'] . "</a>&nbsp; ";
		} else {
			$letter_nav .= "<a href=\"models.php?letter=" . $letter['model_letter'] . "\">" . $letter['model_letter'] . "</a>&nbsp; ";
		}
	}
	$letter_nav .= "</div>";
	
		echo $letter_nav;
	}

?>
<?=$pagination?><br />
<table align="center" border="0" cellspacing="8" cellpadding="0" class="index-updates" width="100%">
<?
$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 = "<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>";
	}	
	// FAV PAGE ONLY
	
$icon = $modelsweb.$row['model_id']."_icon.jpg";

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

$rate = round($rate,2);

		if ($row['releasedate'] <= $today) {
			$url = "model.php?id=".$row['model_id'];
		} else {
			$url = "#";
		}		
		
?>
<td valign="top" width="33%">
    <table style="width: 100%;"><tr><td align="center">
<?=$fav_html?>
<?php
if(isset($delights)) {
		$de = explode('-',$row['delightdate']);
		//$releasedate = date("F j, Y",mktime(0,0,0,$rd[1],$rd[2],$rd[0]));
		//$delightdate = $de[1]."-".$de[2]."-".$de[0];
		$detxt = date("F Y", mktime(0, 0, 0, $de[1], $de[2], $de[0]));
		echo "<div align=\"center\" class=\"contentname\">";
		echo $detxt;
		echo "</div>";
}
?>
<a href="<?=$url?>"><img src="<?=$icon?>" border="0" class="tn" /></a><br />
<div align="center" class="contentname"><?=stripslashes($row['name'])?></div>
<div align="center" class="contentsub">rating: <?=$rate?><br /><?=$row['total_photos']?> photos
<? if($row['total_videos'] > 0) { ?> | <?=$row['total_videos']?> videos <? } ?>
</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=\"175\">&nbsp;</td>";
}
echo "</tr>";
}
?>
</table>
<?
echo $pagination."<br />";
}
?>