Hi,
As per...
http://www.zen-cart.com/wiki/index.p...dules_from_osC

I was wondering if someone could help me understand this as its the last query type I cant get to work well....
Example...
PHP Code:
$orders_status_query = $db->Execute("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . " WHERE language_id = '" . (int)$languages_id . "'");
  while ($orders_status = tep_db_fetch_array($orders_status_query)) {
    $orders_statuses[] = array('id' => $orders_status['orders_status_id'],
                               'text' => $orders_status['orders_status_name']);
    $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];
  } 
According to the wiki and others it should be something like this...

PHP Code:
$my_var = $db->Execute("query stuff");
while (!$my_var->EOF) {
do_stuff;
$my_var->MoveNext();
} 
but which my_var should it be in the above example?

Ive tried...
PHP Code:
$orders_status_query = $db->Execute("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . " WHERE language_id = '" . (int)$languages_id . "'");
  while (!$orders_status->EOF) {
    $orders_statuses[] = array('id' => $orders_status['orders_status_id'],
                               'text' => $orders_status['orders_status_name']);
    $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];
 $orders_status->MoveNext();
 } 
And that gives a fatal error...
Fatal error: Call to a member function on a non-object

If I try...
PHP Code:
$orders_status_query = $db->Execute("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . " WHERE language_id = '" . (int)$languages_id . "'");
  while (!$orders_status->EOF) {
    $orders_statuses[] = array('id' => $orders_status['orders_status_id'],
                               'text' => $orders_status['orders_status_name']);
    $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];
$orders_status_query->MoveNext();
 } 
The page hangs.

Im confused, if anyone can help me out here to explain a little I would appreciate it!
Thanks in advance.