back to PDO and get strange error on online host not on wamp

[Jacques1]

What does this have to do with any of the suggestions?

 

We've offered two possible solutions, you've instead picked an approach which makes no sense. Now what?

[lovephp]

What does this have to do with any of the suggestions?

 

We've offered two possible solutions, you've instead picked an approach which makes no sense. Now what?

sorry now i get the point

[lovephp]

and this just showing why this also wont work it would show 1 record but the next page is not showing any record

 

$offset = ($page - 1)  * $per_page;
    $start = $offset + 1;
    $end = max(($offset + $per_page), $total);

$query = "SELECT * FROM applied WHERE memberID = :memberID ORDER BY id DESC LIMIT :per_page OFFSET :offset";
        
         $stmt = $db->prepare($query);
         $stmt->bindParam(':per_page', $end, PDO::PARAM_INT);
         $stmt->bindParam(':offset', $start, PDO::PARAM_INT);
         $stmt->bindParam(':memberID', $uid, PDO::PARAM_INT);
         $stmt->execute();

Edited August 5, 2016 by lovephp

[lovephp]

and if i do

 

 

$offset = abs(($page - 1)  * $per_page);

 

it works too