array problem

[sanu]

i have problem putting value in array

<?
function catlist($id){
global $db,$title;
$title=array();
$result=$db->Execute("Select * from table where id='$id'");
 while(!$result->EOF){
   $title[]=array('name'=>$result->fields['name'], 'id'=>$result->fields['id']);
if($result->fields['up']==0) return $title;
else catlist($result->fields['up']);
$result->MoveNext();
}
}
catlist(8);
print(count($title));

it always print 1 but i know it has many results
but when i print out the $result->fields['name'] it works fine i don;t whats wrong in my code

[Natty_Dreadlock]

this

$title[]=array('name'=>$result->fields['name'], 'id'=>$result->fields['id']);

should be:

array_push($title, array('name'=>$result->fields['name'], 'id'=>$result->fields['id']));

This will give u an array with your desired information, cos array_push appends the data to $title.

[sanu]

still it print 1

function catlist($id){
global $db,$title;
$title=array();
$result=$db->Execute("Select * from table where id='$id'");

while(!$result->EOF)
	{
 array_push($title, array('name'=>$result->fields['name'],'id'=>$result->fields['id']));

   if($result->fields['up']=='0')  return;
    else  catlist($result->fields['up']);
    $result->MoveNext();
   }
}
catlist(5);
print(count($title));

[Weedpacket]

It's not because the first row returned by the query has its "up" field equal to 0, is it? That would make it return after adding 1 row.

[sanu]

thanks
i just defined $title=array() out side the function and it worked