Do Not Understand A Query With Mysqli In Vbulletin

[zero477]

Hello to all ..

 

It has been some time since I am not around here ...

 

$results = vB::$db->query_read("
   SELECT *
   FROM TABLE
   WHERE lalala='$lalalala'
"); 

echo print_r ($results);

/* When I preint_r the results I see this:

mysqli_result Object ( [current_field] => 0 [field_count] => 16 [lengths] => [num_rows] => 1 [type] => 0 ) 

What is that????

Then I amtrying to get the results with:
*/

while($infocaca = mysqli_fetch_array($results));
{
    $wanttoseethis=$infocaca['columnname'];
}

/* When I echo   $wanttoseethis I cannot see anything 

[Barand]

Use the result object methods to fetch rows EG

 

while ($infocaca = $results->fetch_assoc() )

 

http://www.php.net/manual/en/mysqli-result.fetch-assoc.php