|
get_per_page($per_page_value, $per_page_seg);
$offset = $pagin->get_offset($cur_page_seg, $per_page);
$pagination = $pagin->init_paginate($cur_page_seg, $total_rows, $per_page, $per_page_seg, "?cat=$cat");
$res = mysql_query("SELECT ID, Description, Regular_Price, Sale_Price, Dimentions FROM tbl_gallery WHERE Category_ID = '3' AND IsActive = '1' ORDER BY SortOrder LIMIT $offset, $per_page");
$cnt = mysql_num_rows($res);
if ($cnt > 0) {
$i = 0;
while ($row = mysql_fetch_row($res)) {
$g_id = $row[0];
$g_descr = $row[1];
$g_reg_price = $row[2];
$g_sale_price = $row[3];
$g_dimentions = $row[4];
echo '
';
if (file_exists("files/gallery/" . $g_id . "mini.jpg")) echo(" ");
if (($i+1) % 4 == 0) { echo("![]() "); if ($g_sale_price == '') { echo("$g_descr "); echo("$g_dimentions "); echo("$g_reg_price "); } else { echo("$g_descr "); echo("$g_dimentions "); echo("$g_reg_price "); echo(" "); } echo(" "); } if ($r == 2) break; $i++; } } mysql_free_result($res); //} } else { $res = mysql_query("SELECT ID, Description, Regular_Price, Sale_Price, Dimentions FROM tbl_gallery WHERE Category_ID = $cat AND IsActive = '1' ORDER BY SortOrder"); $total_rows = mysql_num_rows($res); mysql_free_result($res); $per_page_value = 8; $per_page_seg = 'per_page'; //the uri segment for the per page value $cur_page_seg = 'cur_page'; //the url segment for the current page value (generally +1 of per page seg) $per_page = $pagin->get_per_page($per_page_value, $per_page_seg); $offset = $pagin->get_offset($cur_page_seg, $per_page); $pagination = $pagin->init_paginate($cur_page_seg, $total_rows, $per_page, $per_page_seg, "?cat=$cat"); $res = mysql_query("SELECT ID, Description, Regular_Price, Sale_Price, Dimentions FROM tbl_gallery WHERE Category_ID = $cat AND IsActive = '1' ORDER BY SortOrder LIMIT $offset, $per_page"); $i = 0; mysql_data_seek($res, $start); while ($row = mysql_fetch_row($res)) { $g_id = $row[0]; $g_descr = $row[1]; $g_reg_price = $row[2]; $g_sale_price = $row[3]; $g_dimentions = $row[4]; echo ' ';
if (file_exists("files/gallery/" . $g_id . "mini.jpg")) echo(" ");
if (($i+1) % 4 == 0) { echo("![]() "); if ($g_sale_price == '') { echo("$g_descr "); echo("$g_dimentions "); echo("$g_reg_price "); } else { echo("$g_descr "); echo("$g_dimentions "); echo("$g_reg_price "); echo(" "); } echo(" "); } if ($r == 2) break; $i++; } mysql_free_result($res); echo(" "); } mysql_free_result($resCat); ?> |