PHP Code:
<?php
$per_page_b = 24;
$sql_b = "select * from profile ";
$rsd_b = mysql_query($sql_b);
$count_b = mysql_num_rows($rsd_b);
$pages_b = ceil($count_b/$per_page_b)
?>
<div align="center">
<div id="container">
<div class="search-background">
<label><img src="loader.gif" alt="" /></label>
</div>
<div id="orta"></div>
</div>
<div id="paging_button">
<ul>
<?php
//Show page links
for($i_b=1; $i_b<=$pages_b; $i_b++)
{
echo '<li id="'.$i_b.'">'.$i_b.'</li>';
}?>
</ul>
</div>
PHP Code:
<?php
$per_page_bs = 4;
$sqlc_bs = "show columns from profile ";
$rsdc_bs = mysql_query($sqlc_bs);
$cols_bs = mysql_num_rows($rsdc_bs);
$page_bs = $_REQUEST['page'];
$start_bs = ($page_bs-1)*4;
$sql_bs = "select id,resim0,adi,fiyat,big,adres from profile where big=1 order by rand() limit $start_bs,4";
$rsd_bs = mysql_query($sql_bs);
?>
<?php
while ($rows_bs = mysql_fetch_assoc($rsd_bs))
{
echo'<li class="marg_right1">';
echo'<a href="'. $site . $rows_bs['adres'].'.html" id="various3"><img src="resimler/'. $rows_bs['resim0'] .'" alt="" width="213" height="320"></a>';
echo'<div style="top: 346px;" class="box1">';
echo'<div class="alan_orta">';
echo'<p class="adi">'.$rows_bs['adi'].'</p>';
echo'<p class="line_height"><span class="color1">Saatlik ـcret:</span><br/>';
echo'<span class="font1 line_height">' .$rows_bs['fiyat']. ' TL </span></p>';
echo'<a href="'. $site . $rows_bs['adres'].'.html" id="various3"></a>';
echo'</div>';
echo'</li>';
}?>
This is my pagination script.
I am trying to ramdomize the results so that everyone has a chance of being on the first page, but I don't know how to hold it after the first page, when I click on page 2, it randomizes the results again, and puts some of the ones on the first page on the second.
What can i do?
Comment