[Resolved] using mysql_fetch_object on an enum array

[ppowell]

This is bound to happen before I leave on vacation, ugh..

I have this constructed loop:

while($row = @mysql_fetch_object($results)) {
  // DO STUFF WITH $results
}

This is fine as long as $results comes direct from the mysql_db commands and results in an associative array $results.

However, the SearchPerformer-generated results is not associative, it's an enumerative array of objects. This then will cause mysql_fetch_object to choke.

Other than the dreaded prospect of rewriting the while loop, the very last thing I want to do (it's a cool 100+ lines of web-designer code in about 20 different scripts), I thought about the possibility of doing the same thing, mysql_fetch_object, only allowing it to call an enumerative array instead of an associative one. Other than that I don't have a clue how to do this without a very nasty rewrite.

Help.. again.. and again and..

Phil

[tsinka]

Hi,

please post the complete (or at least a part) of the while loop. That makes it easier to find a possible solution.

Thomas

[ppowell]

Thanx, however, I decided to do away with mysql_fetch_array and mysql_fetch_object, the while loop and all in between and use the object building array mechanism in the MySQLQuery object that we have here at work and now everything's an enumerative array of objects and no more worries about the while loop!

Thanx though!

Phil