GROUP BY help

[luminous]

I have two tables with a structure as follows:

 

Table 1:

 

id_text - key

long_desc

 

Table 2:

 

id_text - key

id_product

 

I'm trying to achieve returning an array as follows, where there are one to many id_products to each id_text fields:

 

array(

 

array(

[id_text]=>1

[long_desc] = > Description goes here

                array( //product IDs

                          [0]=>23,

                          [1]=>17

                          )

)

 

)

 

at the moment I am retrieving a column for each and not grouped as above:

 

Array (

[0] => Array (

[id_product] => 23 [long_desc] => Description goes here[id_text] => 1

)

[1] => Array (

[id_product] => 17 [long_desc] => Description goes here[id_text] => 1

 

can anyone help me?

 

 

)

[Twitch]

Have you tried a query like this?

SELECT *
FROM
  Table1
  INNER JOIN Table2 ON (Table1.id_text = Table2.id_text)
GROUP BY id_product