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

[tips007]

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'];
} 

[lat9]

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

[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'];
  $aaa->MoveNext();
}

[tips007]

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?

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'];
  $aaa->MoveNext();
}

[swguy]

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?

[DrByte]

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.