Fatal error need help

[msalman]

hey all,

I've a php file and it amkes some quries to database and when i try to run it, it give me following error

Fatal error: Call to a member function on a non-object in /home/content/I/s/l/mydomain/html/forums/includes/myfile.php on line 5

this is the code that i've so far in myfile.php

<?php
// i'm calling this function in another php file
     function displayIndex() 
     {
// this is line 5
        $query = $db->query_read("SELECT DISTINCT chpNo_en, chpName_en FROM quran_en ORDER BY chpNo_en ASC"); 

        $indexArray;
        $cnt = 0;

        while ($row = $db->fetch_array($query)) {

              $indexArray[$cnt]['chpNo'] = $row['chpNo_en'];
              $indexArray[$cnt]['chpName'] = $row['chpName_en'];

              $verses =  $db->query_read_first("SELECT COUNT(ayatNo_en) AS verses FROM quran_en WHERE chpNo_en=". $row['chpNo_en']);

              while ($verse = $db->fetch_array($verses)) {
                  $indexArray[$cnt]['verses'] = $verse['verses'];
              }

              $cnt++;
        }
        $cnt = 0;
        $query = $db->query_read("SELECT DISTINCT chpName_ar, chpNo_ar FROM quran_ar ORDER BY chpNo_ar ASC");
        $array;

        while ($row = $db->fetch_array($query)) {
              $array[$cnt] = $row['chpName_ar'];
              $cnt++;
        }

        for ($i = 0; $i < $cnt; $i++) {
              if ($i <  38) {
                 $indexArray[$i]['chpName'] = $indexArray[$i]['chpName'] . $array[$i];
              } else if ($i >= 38) {
                 $indexArray[$i]['chpName'] = $indexArray[$i]['chpName'] . $array[$i+1];
              }
        }

        return $indexArray();
     }
?>

[Dismounted]

Try

PHP Code:

<?php

     function displayIndex() // i'm calling this function in another php file
     {
        global $db;

        $query = $db->query_read("SELECT DISTINCT chpNo_en, chpName_en FROM quran_en ORDER BY chpNo_en ASC"); // this is line 5

        $indexArray;
        $cnt = 0;

        while ($row = $db->fetch_array($query)) {

              $indexArray[$cnt]['chpNo'] = $row['chpNo_en'];
              $indexArray[$cnt]['chpName'] = $row['chpName_en'];

              $verses =  $db->query_read_first("SELECT COUNT(ayatNo_en) AS verses FROM quran_en WHERE chpNo_en=". $row['chpNo_en']);

              while ($verse = $db->fetch_array($verses)) {
                  $indexArray[$cnt]['verses'] = $verse['verses'];
              }

              $cnt++;
        }
        $cnt = 0;
        $query = $db->query_read("SELECT DISTINCT chpName_ar, chpNo_ar FROM quran_ar ORDER BY chpNo_ar ASC");
        $array;

        while ($row = $db->fetch_array($query)) {
              $array[$cnt] = $row['chpName_ar'];
              $cnt++;
        }

        for ($i = 0; $i < $cnt; $i++) {
              if ($i <  38) {
                 $indexArray[$i]['chpName'] = $indexArray[$i]['chpName'] . $array[$i];
              } else if ($i >= 38) {
                 $indexArray[$i]['chpName'] = $indexArray[$i]['chpName'] . $array[$i+1];
              }
        }

        return $indexArray();
     }
?>

[msalman]

ok thanks, it worked, could you please refer me to some source that lists all these global variable which are required for vbulletin?

[Dismounted]

Only $vbulletin and $vbphrase are probably essential. I only globalized $db because you were using that. I prefer using $vbulletin->db instead.