Error with query and while loop

Question

Been trying to figure this out for a couple of days now. Havn't come up with any solution and I've searched and asked friends about it. But with no good results.

When I user $db->query(); It gives me this error: Fatal error: Call to a member function fetch() on a non-object

And when I use prepare, I get no result at all, just a blank page.

<?php
$query = $dbh->query("SELECT name, ad_offer, content, expiration_date FROM biz_ads ORDER BY id DESC LIMIT 0,5");
while($row = $query->fetch(PDO::FETCH_NUM)) {
        $name = $row[0];
        $ad_offer = $row[1];
        $content = $row[2];
        $expiration_date = $row[3];
        ?>
        <div class="name"> 
        <?php 
        echo $name;
        ?>
        <div class="ad_offer">
        <?php
        echo $ad_offer;
        ?>
        </div>
        <div class="content">
        <?php
        echo $content;
        ?>
        </div>
        <div class="expiration_date">
        <?php
        echo $expiration_date;
        ?>
        </div>
    <?php
        }
?>

Any help is appreciated. The weird thing is, that I actually got a old similar query to work not long ago at all. Still not working.

<?php

$hostname = 'localhost';
$username = 'root';
$password = '';

$dbh = new PDO("mysql:host=$hostname;dbname=broet;", $username, $password);

?>

Can you put the output of var_dump($query) after your first line ? — Antoine, Jun 03 '13 at 22:19
So the problem probably comes $dbh, can you edit your code and add the creation of this variable ? — Antoine, Jun 03 '13 at 22:24
Sounds like the query failed. Try outputting `$dbh->errorInfo()` after your query. — showdev, Jun 03 '13 at 22:24
Did you try to manually execute your query? (in PHPMyAdmin for example). It looks like the query fails. (OT: Use @name for answers, so the people who ask questions get notified you responded) — MarioP, Jun 03 '13 at 23:02

score 0 · Accepted Answer · answered Jun 04 '13 at 00:05

0

$query = "SELECT name, ad_offer, content, expiration_date 
         FROM biz_ads 
         ORDER BY id DESC 
         LIMIT 0,5";
$stmt = $dbh->prepare($query);
$stmt->execute()or die("error");

answered Jun 04 '13 at 00:05

Lance

4,736
16
53
90

Sorry, my bad! WORKS! THANK YOU SO MUCH @LANCE – user2328659 Jun 04 '13 at 08:38

Error with query and while loop

1 Answers1