return array method

[JakesSA]

I posted this question a while back, but never got it working.

The idea that I have be the following method in my class, is that I dont want to produce any html from the object created, but only to produce the values for me.

I want those values stored in an assoc array, so that when I call the obect through some procedural, I want to be able to loop out that assoc array the has been stored in the objects mem...

 function returnUser()
	     {
        dbConnect::dbConnect();
       if($this->dbConnect == false)
                     {
	          return $this->error = "connection faild";
	      }
    $this->query = "SELECT * FROM user";
   $result = mysql_query($this->query) or die(mysql_error());

  while($data[] = mysql_fetch_assoc($result)){

 //**** this is  where I want to store the assoc array to loop out latter

// more than 1 user in record set to loop out
       $this->aData =  array(array($aData['uName'], $aData['uSurname']));

   return $this->aData;

 //**** but having problems returning the values in an array to loop out 

     	} 
     }

so when called the new object

// this is where the second problem comes in ....to loop out the object 

$obj = new myUser();

$data = $obj->aData;

//**This is how Im hoping to have the values stored as to loop out
$data = array( 
              array("uName" => "Joe", "uSurname" => "Soap"),  

              array("uName" => "Bob", "uSurname"=>"Long") 
        );
//***************************************************

foreach($data as $setName)  

    { 
        foreach ($setName as $var=>$val) 
        { 
            print "<td>" . $var. "</td><td>" . $val . "</td>"; 
        } 
    }

Bit of a long one but thanks in advance

P.S If anyone knows of a better way to do this....Im all ears.

Thanks

[laserlight]

cant you try something like:

function returnUser()
{
	//connect to database
	dbConnect::dbConnect();

//check if connection successful
if ($this->dbConnect == false)
{
	return $this->error = "connection failed";
}

//run the query
$this->query = "SELECT * FROM user";
$result = mysql_query($this->query)
	OR die(mysql_error());

/* loop the results
 * store each row as an array
 * that is an element of $this->aData array
 */
while ($row = mysql_fetch_assoc($result))
{
	$this->aData[] = array(
		"uName" => $row["uName"],
		"uSurname" => $row["uSurname"]
		);
}
}

[JakesSA]

When I var_dump() from with in the method, all the values are there, but the problem is... how do I loop those values out, when the object has been called?

The following only returns the last value of the set

$myObj = new user();
$myObj->returnUser(); 

// only last value being returned

foreach($myObj->aData as $newVal)
   {
	foreach ($newVal as $var=>$val)
	   {
	       print $var. " = " .$val;
	    }
}