mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given

Asked May 09 '13 at 01:08

Active May 09 '13 at 01:08

Viewed 39 times

print_r($name);

$results = $db->query('
        SELECT `field_value`,`user_id`
        FROM `xf_user_field_value`
        WHERE field_value = "'.$name.'"
');

$storedtime = $db->query('
        SELECT `last_donation_date`
        FROM `merc_donor`
        WHERE last_donation_date = '.$time.'
');

$info = mysqli_fetch_array($results);

The error it's giving me is mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given Everywhere I look it tells me it's because of null variables, but printing $name out tells me that it's NOT null! I'm totally lost!

asked May 09 '13 at 01:08

Rhododendron

Except I clearly stated that the query works and $name is a real variable. The issue in that thread is different from my issue. – Rhododendron May 09 '13 at 01:11
@EllisonPatterson Check what `$results` contain using `print_r`. – Yogesh Suthar May 09 '13 at 01:15
http://pastebin.com/h9Hx4Vqu – Rhododendron May 09 '13 at 01:22
I believe you should be able to the rows using $info = $results->fetch_array(MYSQLI_ASSOC); instead of $info = mysqli_fetch_array($results); – medina May 09 '13 at 01:23
Fatal error: Call to undefined method Zend_Db_Statement_Mysqli::fetch_array() in /home/billyraycyrus/public_html/xenforo/library/Donation/Game.php on line 47 – Rhododendron May 09 '13 at 01:30

mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given

0 Answers0