$aaa = mysql_query($aaa_query) instead of while (!$aaa->EOF)

here are two methods i've tested successfully
i wanna know if i use METHOD B, will i get any insecurity ?

$aaa_query = ""select ...";

METHOD A (zen cart default method)

$aaa = $db->Execute($aaa_query);
while (!$aaa->EOF) {
  echo $aaa->fields['bbb'];
}

METHOD B

$aaa = mysql_query($aaa_query);
while($row = mysql_fetch_array($aaa)){
  echo $row['bbb'];
}

If you go with option A (i.e. using the integrated Zen Cart database calls), you'll be future-proofed when the mysql* function calls are removed from a future PHP version (they're deprecated in PHP 5.5).

Method A is the best one to use within Zen Cart.

But you've got an error in it. You're missing an important line, else you'll end up in an endless loop:

$aaa = $db->Execute($aaa_query);
while (!$aaa->EOF) {
  echo $aaa->fields['bbb'];
[B]  $aaa->MoveNext();[/B]
} 

sorry i forgot writing $aaa->MoveNext(); just now

yes, Method A is good for zen cart and i use this method for many files for my zen cart,
but for one of my files, i get an issue by this method, then i have to try Method B, it works.
i'm not sure Method B is safe enough, or will it bring any problem? in the future?

DrByte:

Method A is the best one to use within Zen Cart.

But you've got an error in it. You're missing an important line, else you'll end up in an endless loop:

$aaa = $db->Execute($aaa_query);
while (!$aaa->EOF) {
echo $aaa->fields['bbb'];
[B] $aaa->MoveNext();[/B]
}

If Method A gives you an issue, then perhaps the file is not truly integrated into Zen Cart. For example, have you included application_top.php?

Or you're using it from within a function or class, but haven't made the $db global, and thus it's unreachable due to the scope of your code.