Working With Arrays

[likelylad]

Hi All
I am trying to get the following piece of code to work

while (!$rs->EOF)  //carry on looping through while there are records
{
$count=$fld[1];
$name=$fld[0];
echo $name.$count;
$thecount[$name]=$count;
echo $thecount[$name];

    $rs->MoveNext(); //move on to the next record
}

The Following line from above shows the expected information

echo $name.$count;

However the following line shows nothing

echo $thecount[$name];

The Apache error log shows the following

PHP Warning: Illegal offset type in C:\\web\\web\\web.php on line 44
PHP Warning: Illegal offset type in C:\\web\\web\\web.php on line 45


Lines 45 and 45 are

$thecount[$name]=$count;
echo $thecount[$name];

Thanking in advance for any help received

 

[jpadie]

how does the loop know what $fld is? i cannot see it defined or returned anywhere.

 

[likelylad]

Hi jpadie

That is only a portion of the code. I know that $fld is OK, as I can echo out the information held in the array.

 

[jpadie]

i doubt that you're right. you have plotted a loop that iterates a recordset but you are not, in the loop, using the $rs object to return any data. ie. the $fld array will be static for _every_ row of the recordset.

additionally the error that you are receiving indicates that $thecount is an object and you are trying to address a property of that object as if it were an array. this does not work. to address an object property this is the right syntax

$object->property

 

[likelylad]

I sorted out my issue with the following code. I don't know if its an idea solution but it works.

for ($i=0; $i < $num_columns; $i++) {
    $fld[$i] = $rs->Fields($i);
}

while (!$rs->EOF)  //carry on looping through while there are records
{
$arrayinfo="\"".$fld[0]."\"=>$fld[1],";
$arrayinfolist=$arrayinfolist.$arrayinfo;

    $rs->MoveNext(); //move on to the next record
}

//close the connection and recordset objects freeing up resources 
$rs->Close();
$conn->Close();

$cleanarraylist=rtrim($arrayinfolist,",");

$buildarray="\$thevar=array($cleanarraylist);";

 

[likelylad]

Sorry left a very important bit out at the end

eval("$buildarray");

 

[jpadie]

i can't see how that works as you are never refreshing your field values within the iteration loop.

surely something like this is what you're after?

$array = array();
$rs->moveFirst();
do{
	$array[] = array(trim($rs->Fields(0)), trim($rs->Fields(1)));
        $rs->moveNext();
} while (!$rs->EOF);

echo "<pre>" . print_r($array, true) . "</pre>";