StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7410941
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-09-14T03:28:43.050
FavoriteCount
0
LastActivityDate
2011-09-14T03:28:43.050
LastEditDate
LastEditorUserId
0
OwnerUserId
216941
ParentId
7410669
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Ah, nice problem. I've actually had to re-implement this on a number of occasions. This ought to work for you: <pre><code> class Counter { private $bases; private $currNum; private $increment; private $maxVal; public function __construct($bases) { $this->bases = $bases; $this->maxVal = 1; $this->currNum = array(); foreach ($bases as $base) { $this->maxVal *= $base; $this->currNum[] = 0; } $this->increment = 0; } public function increment() { ++$this->increment; for ($i = count($this->currNum) - 1; $i > -1; --$i) { $val = $this->currNum[$i] + 1; if ($val >= $this->bases[$i]) { $this->currNum[$i] = 0; } else { $this->currNum[$i] = $val; return; } } } // TODO handle overflows public function hasNext() { return $this->increment < $this->maxVal; } public function getNum() { return $this->currNum; } public function getIncrement() { return $this->increment; } } // your sample arrays $arrays = array( array('a', 'b', 'c'), array('d', 'e', 'f'), array('g', 'h', 'i') ); // parameter to counter changes based on how many arrays you have // if you have 4 arrays of len 4, it'll be $counter = new Counter(array(4,4,4,4)); // it'll work with arrays of varying lengths as well. // so if you have 1 array of len 2, another of len 3 and a third of len 4: // $counter = new Counter(array(2,3,4)); $counter = new Counter(array(3,3,3)); $result = array(); while ($counter->hasNext()) { $indexes = $counter->getNum(); //print_r($indexes); $result[] = array(); foreach ($indexes as $arr => $index) { $result[count($result) - 1][] = $arrays[$arr][$index]; } $counter->increment(); } print_r($result); </code></pre> I changed $array['A'] $array['B'] to be indexed as $array[0] $array[1] etc to make it easier to work with. <pre><code>counter->getNum() </code></pre> returns the array indexes. You can choose whether or not you want to actually pick that element.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POcombine 2 dim array elements in PHP
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMatt Crinklaw-Vogt
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POcombine 2 dim array elements in PHP
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThank you, works like a charm!
 singulars
 PostPostId
 PO
 UserUserId
 USShila
2. CO@Shila cool. can you up vote or accept if that's the case? ;) ty
 singulars
 PostPostId
 PO
 UserUserId
 USMatt Crinklaw-Vogt

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.