tep_db_fetch_array in while please help me understand it!

[Reesy]

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...

$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...

$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...

$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...

$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.

[DrByte]

You've got mismatched object names ... shown in red ...
and you're missing the pointers to the fields ... shown in blue:

$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->fields['orders_status_id'],
                               'text' => $orders_status->fields['orders_status_name']);
    $orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name'];
$orders_status_query->MoveNext();
 }

[Reesy]

Exceeeeeeeeeeeeeeellllllllllllllent Chris!
Thank you very much for the pointers and congrats on the recent release.

[Reesy]

Sorry,
Im still not 100% on this, where it says my_var should this be the same throughout the query please?
Thanks

[Merlinpa1969]

try this

$orders_status = $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->fields['orders_status_id'],
                               'text' => $orders_status->fields['orders_status_name']);
    $orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name'];
$orders_status->MoveNext();
 }

[Reesy]

Yes mate you do
Ah sorry Merlin, just figured it out but thank you for your help!!!!!!!!!