if (isset($_GET["page"])) {
$page = abs($_GET["page"]);
} else {
$page = 1;
}
$start_from = ($page - 1) * $max_results;
$Total_Animals = "SELECT Animals_ID FROM animal WHERE Verified='No' AND Added_By={$_SESSION['Member_ID']}";
$totalresults = mysql_query($Total_Animals);
$total = mysql_num_rows($totalresults);
$total_pgs = ceil($total / $max_results);
$This_Page_SQL = "SELECT Animals_ID, Animal, Breed, Price, Image_1 FROM animal WHERE Verified='No' AND Added_By={$_SESSION['Member_ID']} ORDER BY Views ASC LIMIT {$start_from}, {$max_results}";
$result = mysql_query($This_Page_SQL, $conn) or die(mysql_error());
$this_page_total = mysql_num_rows($result);
$this_page_total_2 = mysql_num_rows($result);
$this_page_total = ($page - 1) * $max_results + $this_page_total;
$posision = getStartPossion($page, $max_results);
$itemstart = $start_from + 1;
if ($total != 0) {
if ($max_results > $total) {
echo "Showing {$itemstart} - {$total} of {$total} Animals<br><br>";
} else {
echo "Showing {$itemstart} - {$this_page_total} of {$total} Animals<br><br>";
}
} else {
echo "Showing 0 - 0 of 0 Businesses<br><br>";
}
//
while ($newArray = mysql_fetch_array($result)) {
//$id = $newArray['ID'];
$Animals_ID = $newArray['Animals_ID'];
$Animal = $newArray['Animal'];
$max_results = 10;
if (isset($_GET["page"])) {
$page = $_GET["page"];
} else {
$page = 1;
}
$start_from = ($page - 1) * 10;
$totalcars = "SELECT Product_ID FROM product WHERE Verified='No'";
$totalresults = mysql_query($totalcars);
$total = mysql_num_rows($totalresults);
$total_pgs = ceil($total / $max_results);
$sql = "SELECT Product_ID, Animal, Product, Price, Image, Added_By FROM product WHERE Verified='No' LIMIT {$start_from}, {$max_results}";
$result = mysql_query($sql, $conn) or die(mysql_error());
$this_page_total = mysql_num_rows($result);
$this_page_total = ($page - 1) * $max_results + $this_page_total;
$posision = getStartPossion($page);
$itemstart = $start_from + 1;
if ($total != 0) {
if ($max_results > $total) {
echo "<br>Showing {$itemstart} - {$total} of {$total} Products<br><br>";
} else {
echo "<br>Showing {$itemstart} - {$this_page_total} of {$total} Products<br><br>";
}
} else {
echo "<br>Showing 0 - 0 of 0 Products<br><br>";
}
// , , , Price, , Added_By
while ($newArray = mysql_fetch_array($result)) {
$Product_ID = $newArray['Product_ID'];
$Animal = $newArray['Animal'];
$Product = $newArray['Product'];
