PHP - Pagination

[cyates]

Tweet

Damn im absolutely shattered ...
less than 4 hours sleep in last 2 days

can anyone see what ive messed up here because my body and mind seems to have given up ..

$limit = 2;
mysql_select_db($dbn, $dbc);
$cquery = "SELECT count(*) from datafeed";
$cdoresult = mysql_query($cquery, $dbc);
$cresult = mysql_fetch_assoc($cdoresult);
$totalrows = mysql_num_rows($cresult);
if(empty($page)){    // Checks if the $page variable is empty (not set) 
        $page = 1;      // If it is empty, we're on page 1 
    } 
    $limitvalue = $page * $limit - ($limit);  
    // Ex: (2 * 25) - 25 = 25 <- data starts at 25 
     
$query  = "SELECT * from datafeed WHERE type='Divan Bed' LIMIT $limitvalue, $limit";
$doresult = mysql_query($query, $dbc);
$result = mysql_fetch_assoc(doresult);
?> 

Recordset Nav

 <?php if($page != 1){  
        $pageprev = $page--;        
        echo("<a href=\"divan-beds.php?page=$pageprev\">PREV".$limit."</a> ");   
    }else 
        echo("PREV".$limit." ");  
        // If we're on page 1, PREV is not a link 
   if(($totalrows - ($limit * $page)) > 0){ 
        
        $pagenext   = $page++; 
            
        echo("<a href=\"divan-beds.php?page=$pagenext\">NEXT".$limit."</a>"); 
      
    }else{ 
        echo("NEXT".$limit);  

    } 

?>

any help appreciated.. really need my sleep

[cyates]

forgot to mention ..

its adding teh correct num of products .. just a problem with prev & next

[cyates]

also getting
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\kingsizebeds\divan-beds.php on line 8

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\wamp\www\kingsizebeds\divan-beds.php on line 18

$limit = 6;
mysql_select_db($dbn, $dbc);
$cquery = "SELECT count(*) from datafeed";
$cdoresult = mysql_query($cquery, $dbc);
$cresult = mysql_fetch_assoc($cdoresult);
LINE 8 ->   $totalrows = mysql_num_rows($cresult);
if(empty($page)){    // Checks if the $page variable is empty (not set) 
        $page = 1;      // If it is empty, we're on page 1 
    } 

    $limitvalue = $page * $limit - ($limit);  
    // Ex: (2 * 25) - 25 = 25 <- data starts at 25 
     
$query  = "SELECT * from datafeed WHERE type='Divan Bed' LIMIT $limitvalue, $limit";
$doresult = mysql_query($query, $dbc);
LINE 18 -> $result = mysql_fetch_assoc(doresult); 

[MoonBug]

Quick scan says to me 'SELECT count' query wont return rows but the number of records in your table, or if it does perhaps this will be 1?

Also Line 18 is missing a '$' -> mysql_fetch_assoc($doresult)

[cyates]

fixed the $ error but still nothing..

returning products but if i set limit to 2
it will only display 2 products and teh URLs for prev & next are inactive

any one any ideas ?

[cyates]

and also if i add page=2 or page=3 etc to the url in teh address bar it only returns the same results as it does without $page being set

[cyates]

also so people know where i got this code.. it was from here
PHP Help: Pagination: Easy as PREV 1 2 3 NEXT

ive ammeded it to match my db but everything else is teh same so dont see teh problem

[drivetowin]

try adding

$page=$_GET['page'];

to the start of your code and then putting page=2, page=3 etc after your url.

[cyates]

did nothing ...
still same as before

[drivetowin]

can you put in a couple of lines after line 8

echo ("Totalrows = " . $totalrows);
echo ("Page = " . $page);

and see what they output.

[cyates]

Totalrows = 1
Page =

appreciate the help . i just wanna pull my hair out at the mo

[drivetowin]

when you call the page are you putting

http://www.yourdomain.co.uk/thispage.php?page=2

The ? is significant.

Also can you change line 8 to say

$totalrows = mysql_num_rows($cdoresult);

And then see what it outputs for page and totalrows

[cyates]

yes & line is 8 is already $cdoresult

really confusing me this one is lol

[drivetowin]

Do you want to email me the whole page to info @ findmethebestprice.co.uk so I can look at the whole code, might give me a clue whats going on.

[cyates]

ok cheers

email on way now