My pdo read statment its not working correctly

Question

Im trying to devellop a pagination system and Im having an strange issue. I have this code below and the code is always entering in my if condition saying there are 0 results. But I have the sql statment correct when I do a print_r. Can you see if theres something wrong that I´m not seeing?

 $pag = (empty($_GET['pag']) ? '1' : $_GET['pag']);
            $max = 3;
            $begin = ($pag * $max) - $max;
            $readPages = $pdo->prepare("SELECT * FROM pages where id_numb IS null LIMIT :beg,:ma");  
            $readPages->bindValue(":beg", $begin);
            $readPages->bindValue(":ma", $max);    
            $readPages->execute();
            $num_rows = $readPages->rowCount();

            if(!$num_rows >= 1)
            {
                echo '0 results';
            }

do you have a records with null id_numb fields? Did you check that `$begin` is being correctly calculated? — Marc B, Apr 01 '14 at 22:00

score 1 · Answer 1 · edited May 23 '17 at 12:11

1

always enable exception mode for PDO to be notified of SQL errors
for the LIMIT clause you have to set PDO::PARAM_INT explicitly

edited May 23 '17 at 12:11

Community

1
1

answered Apr 01 '14 at 22:01

Your Common Sense

156,878
40
214
345

score 0 · Answer 2 · answered Apr 01 '14 at 22:01

0

        $num_rows = readPages->rowCount();
                    ^---missing $. A constant object? no way...
        print_r($lerCat);
                 ^^^^^^--- undefined variable

answered Apr 01 '14 at 22:01

Marc B

356,200
43
426
500

Thanks but thats no the problem, I put that wrong doing the translation! – OzzC Apr 01 '14 at 22:03

My pdo read statment its not working correctly

2 Answers2