Accessing a database table

[Davep]

Hi,
I have downloaded the latest Zen cart and installed it okay.
Everything seems to be working well.

Now I have added a table to the database using phpMyAdmin.

When I try to access this table I get the error:
Call to a member function on a non-object

Can someone tell me what may be wrong?
Thanks,
Dave

[superprg]

Error string seems to be the php coding problem
Can you post the code here you tried to read the table?
May be you have forgotten to include some file(s)?

[Davep]

Error string seems to be the php coding problem
Can you post the code here you tried to read the table?
May be you have forgotten to include some file(s)?

Here is the code:

     $licences = array(); 
      $this->licences_html = $this->licences_text = ''; 
      for ($i=0, $n=sizeof($this->products); $i<$n; $i++) { 
          $db->Execute('UPDATE products_licences SET orders_id='.$zf_insert_id 
                       . ' WHERE products_id='.(int)$this->products[$i]['id']
                           . ' AND orders_id IS NULL' 
                           . ' LIMIT '.$this->products[$i]['qty'] 
                       ); 
          $dbres = $db->Execute('SELECT licences_code FROM products_licences' 
                       . ' WHERE products_id='.(int)$this->products[$i]['id'] 
                           . ' AND orders_id='.$zf_insert_id 
                       ); 
        while(!$dbres->EOF) { 
            $this->licences_html .= '<p>'.(int)$this->products[$i]['id'].':<br><span class=licences_code>'.$dbres->fields['licences_code'].'</span></p>';		
            $this->licences_text .= "Here is the Serial Number for your program "."\n".$this->products[$i]['name'].":\n".$dbres->fields['licences_code']."\n\n"; 
            $licences[(int)$this->products[$i]['id']][] = $dbres->fields['licences_code']; 
            $dbres->MoveNext(); 
        } 
      }

I am getting the error on this line:
$db->Execute('UPDATE products_licences SET orders_id='.$zf_insert_id

Thanks,
Dave

[superprg]

Fine, where did you declare $db in the code?

[Davep]

Fine, where did you declare $db in the code?

Well, that was it. I did not declare $db.
It is working well now.

Thank you,
Dave