[PHP] array from mysql help?

2001-07-24 Thread Jaxon
Hi, I want to create an array like this: $tree = array ( first = array (stuff1, stuff2, stuff3), second = array (stuff1, stuff2) ); based on tree of information, stored in a database table: level parent_cat child_cat -- 1 first first 1

RE: [PHP] array from mysql help?

2001-07-24 Thread Remo Pini
To be destructive, I would use a sensible data-representation in mysql, yours seems to suck... something like table x idx as integer, auto_increment, primary key node as text parent as int (this points to the parent primary key) But here is what I would do with the current data structure