[Resolved] Get out of array

Reformed

I'm experiencing brain fade and cannot figure out how to get out of a multidemesional array. I want to get out of the master array to access the sub-arrays. This is what I'm trying to do:

//for each user of the system, query them and get their id's
		$dbObj = new CommonQueries();
		$userQuery = "SELECT DISTINCT ts_employee_id
		FROM burb_timesheets";
		$userList = $dbObj->getAllQuery($userQuery);



	$userList = implode(',',$userList);
	echo $userList;

I need to create a comma separated list of id's for another query. The $userList is a mulitidemensional array from PEAR DB and all I want is to access the values and run them through implode, but for some reason I can't get my brain around this problem. Any suggestions?

LordShryku

What's your array loop like? I'd think you'd have to loop if it was multi-dimensional...

$string = "";
foreach($array as $a) {
   $string .= $a['element'].",";
}
$string = substr($string,0,-1);

Reformed

Here the output of my array straight from the result set:

Array (  [0] => Array  (  [0] => 1  )  [1] => Array  (  [0] => 10  )  )

LordShryku

Will there ever be more than one element inside of the second array? If not, you can code it like this:

$string = "";
foreach($userList as $u) {
   $string .= $u[0].",";
}
$string = substr($string,0,-1);

If so, you'll have to loop again

$string = "";
foreach($userList as $u) {
   foreach($u as $a) {
      $string .= $a.",";
   }
}
$string = substr($string,0,-1);

BTW...where is that TV shop for the AZphp meetups? I'm going to try to make one of them sometime here...

Reformed

Cool, the first loop worked. That was exactly what I needed. For some reason I just couldn't think of how to do that.

The TV shop is called Walt's TV and it's on Mill and Southern, just west of Mill on Southern. It's on the left side when your heading west on southern. Here's a map
I've only been to one meeting because I have school on the nights they meet. If you haven't gone before you should. It's fun. They do a presentation of some sort and then it's like a bunch of PHP geeks just hanging out talking shop. Pretty fun.

Thanks for the help.