Getting this query to work with xenforo code

[Member 3639]

Basically i have this code

<?php
 
$db = XenForo_Application::get('db');
 
 
 
while ($category = $db->fetchAll("SELECT * FROM `articles_category` ORDER BY `category_name` ASC"))
 
{
 
    $mydata .= $category['category_name'];
 
}

Which gives me an error of;
ErrorException: Undefined index: category_name - library/EWRporta/Block/MyPhp/myfile.php:8

What is the best way to "define" it?

 

[Mike Tougeron]

That's basically saying that the field 'category_name' doesn't exist in the result. Have you tried doing a var_dump($category); to see what that holds?