Multidimensional array

[ram4nd]

I would like to create a multidimensional array. Whith 2 existing arrays. Just put them together in 1 array.

 

Theese are my arrays:

$results1 = $mysql->doQueryA("SELECT name FROM category_id");
$results2 = $mysql->doQueryA("SELECT name FROM subcategory_id");

[dclamp]

Multidimensional array is not what your looking for. You just want 2 array merged together...

 

try using array_merge()

[ram4nd]

Ok yes, that is right. If I want to put subcategories into categories then i have to do?:

 

array_merge($categories, $subcategories)

[dclamp]

ah i see what you want to do.

 

How is your table setup?

[ram4nd]

Umm, what do you mean by table setup?

 

Sql table setup?:

category - id name

subcategory- id name category_id

[Mark Baker]

Umm, what do you mean by table setup?

I think the point of the question is to determine whether a subcategory is associated with a specific category, because you may be able to execute a single SQL query to retrieve data from both tables in one go

[ram4nd]

Umm, ok it is not associated. It takes data sepperately from sql tables. Like in the post what i did before this.

[dclamp]

Umm, what do you mean by table setup?

I think the point of the question is to determine whether a subcategory is associated with a specific category, because you may be able to execute a single SQL query to retrieve data from both tables in one go

 

Yeah thats what i was getting at...

[Mark Baker]

Umm, ok it is not associated.

category - id name

subcategory- id name category_id

suggests that it is associated, on category_id.

 

Alternatively, you could use a UNION in your query:

SELECT ID,
       NAME
  FROM CATEGORY
UNION
SELECT ID,
       NAME
  FROM SUBCATEGORY