for loop error

drag0n

Here is the error I get:
Warning: Invalid argument supplied for foreach() in /home/httpd/vhosts/path_to_whatever/filename.php on line 82
and this is the line of code on line 82:

		foreach( $rs->fields AS $key => $val )

I have tried almost everything, but cant seem to figure out whats wrong with the syntax. Thanks

devinemke

$rs->fields is either not set or not an array

rachel2004

the first argument needs to be the array name.

drag0n

So what should it be?

rachel2004

What happens if you follow devinemke's suggestion?

TheDefender

dragon, show some code where this ($rs->fields) is being established... Can't help if we don't see code.

drag0n

rs is a query in the database, and I checked the query and it does not seem empty.
rs is set here:

$rs 	= $conn->Execute( $query );

BigBadKev

Hi dragon,

your syntax is correct

foreach($rs->fields AS $key => $val) {
  //......code
}

and I assume you know if inside a object it would be
foreach($this->fields AS $key => $val) {
  //......code
}

or if a instance is made within another object
foreach($this->rs->fields AS $key => $val) {
  //......code
}

So basically its a array been traversed and it can only take a array as its first argument, I believe this is without exception

I suspect its the way you have set the array from the sql or the returned object is in fact not a array at all.

I do this real example

$this->statement = NULL;
$this->statement = "SELECT model_id, model_name from model ORDER BY  model_name ASC;";
$this->sql->sql_execute($this->statement);
$this->sql->select_rows($this->sql->result);
if($this->sql->rows > 0) { 
  while($row = mysql_fetch_array($this->sql->result)) {
    $this->allModels[$row['model_id']] = $row['model_name'];
  }
}

//allModels is ready to be used for the foreach

I would echo out your rs and also check if it is a array as the way you have it the rs appears to be just a sql statement executed.

I hope this helps a little

BBK

BigBadKev

Hi dragon,

something I just noticed is your $rs->fields implys its a var from a class with the class been rs and of course a var fields
The other is you are using the $sql->row_object which means you could use $sql->row_object->name.

So is your fields var set as a class var? otherwise it will fall out of scope if its within a object method, if this is the case then simply make it a class var giving it class wide scope and remove the method var to remove local scope.

BBK