query("SELECT `id`, `title`, `desc`, FORMAT(`cost` * `markup`, 2) AS `price` FROM `jewelery` ORDER BY `id` LIMIT $offset, $perpage;"); } elseif(empty($_GET['type'])) { $cat = mysql_real_escape_string($_GET['cat']); $data = $link->query("SELECT `id`, `title`, `desc`, FORMAT(`cost` * `markup`, 2) AS `price` FROM `jewelery` WHERE `cat` LIKE '%$cat%' ORDER BY `id` LIMIT $offset, $perpage;"); } elseif(!empty($_GET['type'])) { $type = mysql_real_escape_string($_GET['type']); $data = $link->query("SELECT `id`, `title`, `desc`, FORMAT(`cost` * `markup`, 2) AS `price` FROM `jewelery` WHERE `type` = '$type' ORDER BY `id` LIMIT $offset, $perpage;"); } if (empty($_GET['cat']) && empty($_GET['type'])) { $data2 = $link->query("SELECT COUNT(`id`) AS `count` FROM `jewelery`;"); } elseif(empty($_GET['type'])) { // $cat = mysql_real_escape_string($_GET['cat']); $data2 = $link->query("SELECT COUNT(`id`) AS `count` FROM `jewelery` WHERE `cat` LIKE '%$cat%';"); } elseif(!empty($_GET['type'])) { $data2 = $link->query("SELECT COUNT(`id`) AS `count` FROM `jewelery` WHERE `type` = '$type';"); }; $numrows = $data2->fetch_array(); $pages = ceil($numrows['count']/$perpage); if ( $page == 1 ) { $nav = '<<-'; } else { $check_back = true; $nav = ''; }; $nav_add = 0; if ( ($page-5) < 1 ) { $cpage = 1; $nav_add = 5-$page; } else { $cpage = $page-5; }; if ( ($page+5+$nav_add) > $pages ) { $max_page = $pages; if ( $nav_add == 0 ) { $nav_sub = $pages-(5+$page); if ( (($page-5)+$nav_sub) < 1 ) { $cpage = 1; } else { $cpage = ($page-5)+$nav_sub; } } } else { $max_page = $page+5+$nav_add; }; if (empty($_GET['cat']) && empty($_GET['type'])) { if ($check_back == true) { $nav .= " <<- "; }; for($cpage = $cpage; $cpage <= $max_page; $cpage++){ if ($cpage == $page){ $nav .= " $cpage "; } else { $nav .= " $cpage "; }; }; if ($page < $pages) { $nav .= " ->> "; } else { $nav .= " ->>"; }; } elseif(empty($_GET['type'])) { if ($check_back == true) { $nav .= " <<- "; }; for($cpage = $cpage; $cpage <= $max_page; $cpage++){ if ($cpage == $page){ $nav .= " $cpage "; } else { $nav .= " $cpage "; }; }; if ($page < $pages) { $nav .= " ->> "; } else { $nav .= " ->>"; }; } elseif(!empty($_GET['type'])) { if ($check_back == true) { $nav .= " <<- "; }; for($cpage = $cpage; $cpage <= $max_page; $cpage++){ if ($cpage == $page){ $nav .= " $cpage "; } else { $nav .= " $cpage "; }; }; if ($page < $pages) { $nav .= " ->> "; } else { $nav .= " ->>"; }; }; echo $link->error; ?>

Click To Enlarge

"; while($row = $data->fetch_array()) { check_image($row['id'], $link); printf($html, stripslashes($row['id']), stripslashes($row['id'])); }; echo $link->error; $data->data_seek(0); ?>

%s

Price : %s

"; while($row = $data->fetch_array()) { // $price = $row['cost'] * $row['markup']; printf($html, stripslashes($row['title']), stripslashes($row['id']), stripslashes($row['desc']), stripslashes($row['price']), stripslashes($row['title']), stripslashes($row['id']), stripslashes($row['price'])); }; $link->close(); ?>