// Находим общее число страниц

$total = (($tempcount - 1) / $num) + 1;

$total =  intval($total);

$page = intval($page);

if(empty($page) or $page < 0) $page = 1; 

if($page > $total) $page = $total;

// Вычисляем начиная с какого номера

    // следует выводить товары

$start = $page * $num - $num;

$qury_start_num = " LIMIT $start, $num";

}

  $result = mysql_query("SELECT * FROM table_products WHERE visible='1' ORDER BY $sorting $qury_start_num ",$link); 

if (mysql_num_rows($result) > 0)

{

$row = mysql_fetch_array($result);

do

{

if  ($row["image"] != "" && file_exists("./uploads_images/".$row["image"]))

{

$img_path = './uploads_images/'.$row["image"];

$max_width = 200;

$max_height = 200;

list($width, $height) = getimagesize($img_path);

$ratioh = $max_height/$height;

$ratiow = $max_width/$width;

$ratio = min($ratioh, $ratiow);

$width = intval($ratio*$width);

$height = intval($ratio*$height);