Показване последно при Страницизиране

[alabam4eto]

здр. Писах преди време в една друга тема за страницизиране, но се опасявам, че може да не сте видяли

Та как да направя така че да се покажи последното добавено на първо място ? ето и кода за страницизирането

<?
 

mysql_connect(localhost,$user,$password); 
@mysql_select_db($database) or die( "Unable to select database"); 
$query="SELECT * FROM contacts"; 
$result=mysql_query($query); 

$broinastranica = 5; 
$pageNum = 1; 

 

if(isset($_GET['page'])) 
{ 
$pageNum = $_GET['page']; 
} 


$redove = ($pageNum - 1) * $broinastranica; 

$query = " SELECT first,last,phone FROM contacts " . 
" LIMIT $redove, $broinastranica"; 
$result = mysql_query($query) or die('Error, query failed'); 

echo "<table border=1>"; 
 
while($row = mysql_fetch_array($result)) 
{ 
echo '<tr><td>'.$row['first'].'</td><td>'.$row['last'].'</td><td>'.$row['phone'].'</td></tr>'; 
} 

echo"</table>"; 



$query = "SELECT COUNT(email) AS numrows FROM contacts"; 
$result = mysql_query($query) or die('Error, query failed'); 
$row = mysql_fetch_array($result, MYSQL_ASSOC); 
$numrows = $row['numrows']; 


$maxPage = ceil($numrows/$broinastranica); 

$self = $_SERVER['PHP_SELF']; 
$nomeranastranici = ''; 

for($page = 1; $page <= $maxPage; $page++) 
{ 
if ($page == $pageNum) 
{ 
$nomeranastranici .= " $page "; 
} 
else 
{ 
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> "; 
} 
} 





if ($pageNum > 1) 
{ 
$page = $pageNum - 1; 
$predishna = " <a href=\"$self?page=$page\"> [<<] </a> "; 

$parva = " <a href=\"$self?page=1\">[първа]</a> "; 
} 
else 
{ 
$predishna = ' '; 
$parva = ' '; 
} 

if ($pageNum < $maxPage) 
{ 
$page = $pageNum + 1; 
$sledvashta = " <a href=\"$self?page=$page\"> [>>] </a> "; 

$posledna = " <a href=\"$self?page=$maxPage\">[последна]</a> "; 
} 
else 
{ 
$sledvashta = ' '; 
$posledna = ' '; 
} 

echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna; 





?>

+1

 

[Anonymous]

Примерно така ?

<?


mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts";
$result=mysql_query($query);

$broinastranica = 5;
$pageNum = 1;



if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}


$redove = ($pageNum - 1) * $broinastranica;

$query = " SELECT first,last,phone FROM contacts ORDER BY id DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');

echo "<table border=1>";

while($row = mysql_fetch_array($result))
{
echo '<tr><td>'.$row['first'].'</td><td>'.$row['last'].'</td><td>'.$row['phone'].'</td></tr>';
}

echo"</table>";



$query = "SELECT COUNT(email) AS numrows FROM contacts";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];


$maxPage = ceil($numrows/$broinastranica);

$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';

for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href="$self?page=$page">$page</a> ";
}
}





if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href="$self?page=$page"> [<<] </a> ";

$parva = " <a href="$self?page=1">[първа]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href="$self?page=$page"> [>>] </a> ";

$posledna = " <a href="$self?page=$maxPage">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}

echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;





?>