PHP Search pagination problem

[StrikeFreedom]

Hi I've been trying to make pagination for my search results and I have this problem: The first page displays ok but when the max result per page is achieved like $max_results = 2 and it reached 2 the links for the other pages shows but when clicked on it returns nothing and when I go back to page one nothing shows up either can someone help me out? My code is as follow:
[PHP]
<?php

// Database Connection
include 'ccm_chat/database/database.inc';

// If current page number, use it
// if not, set one!

if(!isset($_GET['page'])){
$page = 1;
} else {
$page = $_GET['page'];
}

// Define the number of results per page
$max_results = 10;

// Figure out the limit for the query based
// on the current page number.
$from = (($page * $max_results) - $max_results);

// Perform MySQL query on only the current page number's results

$sql = mysql_query("SELECT * FROM poc_user_data WHERE GENDER LIKE '$gender' AND AGE>='$agemin' AND AGE<='$agemax' AND INTERESTS LIKE '%$interest%' LIMIT $from, $max_results") or die(mysql_error());

while($row = mysql_fetch_array($sql)){
// Build your formatted results here.
echo '

'; echo ''; if(!$row['PICTURE_URL']){ echo 'No Picture Available '; }else{ echo ''; } echo 'User name: '.$row['USER'].''; echo ''; echo ''; echo 'Name: '.$row['NAME'].''; echo ''; echo ''; echo 'Age: '.$row['AGE'].''; echo ''; echo ''; echo 'Gender: '.$row['GENDER'].''; echo ''; echo ''; echo 'Interests: '.$row['INTERESTS'].''; echo ''; echo ''; echo 'Motto: '.$row['MOTTO'].''; echo ''; echo ''; } // Figure out the total number of results in DB: $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM poc_user_data WHERE GENDER LIKE '$gender' AND AGE>='$agemin' AND AGE<='$agemax' AND INTERESTS LIKE '%$interest%'"),0); // Figure out the total number of pages. Always round up using ceil() $total_pages = ceil($total_results / $max_results); // Build Page Number Hyperlinks echo '

Select a Page
';

// Build Previous Link
if($page > 1){
$prev = ($page - 1);
echo "< ";
}

for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){
echo "$i ";
} else {
echo " ";
}
}

// Build Next Link
if($page < $total_pages){
$next = ($page + 1);
echo "";
}
echo "";
?>
[/PHP]

[tristan17]

Hi,

I had done pagination before, and my code has the same structure and i think the problem could be due to the pagination section ie:

instead of :

"// Build Previous Link
if($page > 1){
$prev = ($page - 1);
echo "< ";
}
"

you could do this:

"// Build Previous Link
if($page > 1){

$prev = ($page - 1);
$words=$_GET['Query'];
$type=$_GET['SearchView'];
$search_type=$_GET['SearchType'];
$max_results=20;
$sort=$_GET['Sort'];

echo "  ";
} "

do note :$words,$type, etc are only variables(which i extract the code from my own program of course), these variables are passsed on to the next page or link

instead of :

"for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){
echo "$i ";
} else {
echo " ";
}
}
"

you could do this:

"for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){
echo "$i ";
} else {
$words=$_GET['Query'];
$type=$_GET['SearchView'];
$search_type=$_GET['SearchType'];
$max_results=20;
$sort=$_GET['Sort'];

echo "  ";
}
} "
and instead of :

"// Build Next Link
if($page < $total_pages){
$next = ($page + 1);
echo "";
}
echo "";
?> "

you could do this:

"// Build Next Link
if($page < $total_pages){
$next = ($page + 1);
$words=$_GET['Query'];
$type=$_GET['SearchView'];
$search_type=$_GET['SearchType'];
$max_results=20;
$sort=$_GET['Sort'];



echo "";
} "

it sounds lengthy, but i hope it helps!!

[blanche3]

thank you for this post..
happy birthday to me:D

[blanche3]

excuse me. but is there other simpler codes in search and pagination?
i'm just a novice web developer.. thank you:)