Немога да рзбера къде е грешката
<?php
$page = (int) $_GET['page'];
if (empty($page) or !isSet($page)) {
$page = 1;
}
$dbhost="";
$dbusername="";
$dbpassword="";
$dbname="";
$connect = mysql_connect($dbhost, $dbusername, $dbpassword);
$db = mysql_select_db($dbname,$connect) or die ("Could not select database");
$pp = 3;
$start = ($page * $pp) - $pp;
$result = mysql_query("SELECT * FROM XXXXX RIGHT JOIN XXXXX ON xxxx.product_code = xxxxxx.product_code WHERE xxxxxx.confirmed='0' LIMIT $start");
while($myrow = mysql_fetch_array($result))
{
echo "Резолтатите ";
}
function pageExists($page){
$next = mysqli_query("SELECT * FROM xxxxx RIGHT JOIN xxxxxx ON xxxxx.product_code = xxxxx.product_code WHERE xxxxx.confirmed='0' AND xxxxxx_id >'{$page}' ORDER BY id LIMIT 1");
$prev = mysqli_query("SELECT * FROM xxxxxx RIGHT JOIN xxxxxx ON xxxxxx.product_code = xxxxxx.product_code WHERE xxxxx.confirmed='0' AND xxxxx_id <'{$page}' ORDER BY id DESC LIMIT 1");
return array($prev,$next);
}
list($prev,$next) = pageExists($page);
if(isSet($prev)){
echo'<a href = "?page='.$prev.'">'.$prev.'</a>';
}
if(isSet($next)){
echo'<a href = "?page='.$next.'">'.$next.'</a>';
}
?>
<?php
$page = (int) $_GET['page'];
if (empty($page) or !isSet($page)) {
$page = 1;
}
$dbhost="";
$dbusername="";
$dbpassword="";
$dbname="";
$connect = mysql_connect($dbhost, $dbusername, $dbpassword);
$db = mysql_select_db($dbname,$connect) or die ("Could not select database");
$pp = 3;
$start = ($page * $pp) - $pp;
$result = mysql_query("SELECT * FROM XXXXX RIGHT JOIN XXXXX ON xxxx.product_code = xxxxxx.product_code WHERE xxxxxx.confirmed='0' LIMIT $start");
while($myrow = mysql_fetch_array($result))
{
echo "Резолтатите ";
}
function pageExists($page){
$next = mysqli_query("SELECT * FROM xxxxx RIGHT JOIN xxxxxx ON xxxxx.product_code = xxxxx.product_code WHERE xxxxx.confirmed='0' AND xxxxxx_id >'{$page}' ORDER BY id LIMIT 1");
$prev = mysqli_query("SELECT * FROM xxxxxx RIGHT JOIN xxxxxx ON xxxxxx.product_code = xxxxxx.product_code WHERE xxxxx.confirmed='0' AND xxxxx_id <'{$page}' ORDER BY id DESC LIMIT 1");
return array($prev,$next);
}
list($prev,$next) = pageExists($page);
if(isSet($prev)){
echo'<a href = "?page='.$prev.'">'.$prev.'</a>';
}
if(isSet($next)){
echo'<a href = "?page='.$next.'">'.$next.'</a>';
}
?>