0

I'm trying to figure out how to fix this error... I've seen other questions that have been closed but none of them have fixed my problem, I get that there's an issue with fetch_object() being boolean but I can't figure out why.

here's the my function:

function getNews($objCon, $page = null) {
    $sql = "SELECT id, headline, description FROM cms_news";
    if ($page) {
        $sql .= "WHERE cms_category_id = $page";
    }

    $objectResult = $objCon->query($sql);
    $news = [];
    while ($row = $objectResult->fetch_object()) {
        $news[$row->id] = $row;
    }
    return $news;
}

Thank you!!!

T. H.
  • 79
  • 1
  • 11

1 Answers1

1

You need to add a space when you append your SQL:

$sql = "SELECT id, headline, description FROM cms_news ";

if ($page) {
    $sql .= "WHERE cms_category_id = $page";
}

Your previous SQL string would be:

SELECT id, headline, description FROM cms_newsWHERE cms_category_id = #
Tony
  • 2,890
  • 1
  • 24
  • 35