Dynamic Array

Cloud

Currently I'm trying to crated a system that is kind of like a forum, but its aimed for creating a project outline.

I have a thread id that works like this
1 = thread 1
1_1 = thread: 1 subthread:1 ( so this is a entry under thread 1.

So I can divide the variables and put them in their own variables but I'm trying to figure out how to create a new array with these variables. In the case that we have 1_1 the array should look like:

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

I tried making a dynamic string that had Array([1]=> (etc.) and try stuffing that in a variable, but the array kept getting overwritten in the next database row. So I think the only way I can do this is go:

$overview['subthreads'][[(firstsubthreads_number)][(secondsubthreads_number]

I'm running into problem with this too. I'm basicaly trying to take a array created by explode and then stick all the variables within each other (as an array) starting in the first one.

I'm trying this because this is an overview and there will be steps within steps within steps so I thought this would be the best way. If anyone can think of a better way please tell me.

Thanks!

mmilano

that looks scarry :eek:

can you post what your data structure looks like?

if you just have a thread table, .. then just make 1 more field for 'parent_thread'

thread_id
parent_id
time
title
text

<?
$result = mysql-query("
select * from threads where thread_id=1 or parent_id=1 order by time");
$num = mysql_numrows($result);

for($i=0;$i<$num;$i++)
{
  $array[$i]['id'] = mysql_result($result,$i,'thread_id');
  $array[$i]['time'] = mysql_result($result,$i,'time');
  $array[$i]['title'] = mysql_result($result,$i,'title');
  $array[$i]['text'] = mysql_result($result,$i,'text');
}
?>

but then again, i don't know if that is the data structure you are going for .. so i'm only guessing at a solution.

ws0x9

I'm not sure if I totally follow the first post but what if you use a linked list? Each item in the list would have a reference to another item and then an arrary with all the db fields. Then you would have only one array per item. I'm not totally sure what you are trying to do but I hope that was somewhat helpful.

Cloud

I've progressed a little, but still looking for comments.
Basicaly this is how it works.
In he db this is id 2_1_1-b

Array ( [0] => [2] => Array ( [1] => Array ( [1-b] => Array ( [text] => test2 ) ) ) )

In the db this is 1 and 2_1

Array ( [0] => [1] => Array ( [text] => test0 ) [2] => Array ( [1] => Array ( [text] => test1 ) ) )

And this is my attempt to merge the two fields:

Array ( [0] => [1] => Array ( [text] => test0 ) [2] => Array ( [1] => Array ( [text] => test1 ) ) [1] => [2] => Array ( [1] => Array ( [1-b] => Array ( [text] => test2 ) ) ) )

So I'm not able to split the id into an array but i'm having a problem merging it into the existing array.