[SOLVED] Simple SQL query question

[play_]

i have this query

 

select
projects.id,
projects.type,
projects.title,
projects.url,
uploads.filename
from projects
inner join uploads on uploads.projectID = projects.id
where projects.type = 'lab'"

 

as you can tell it pulls info from projects and uploads table.

 

here's what uploads table look like

 

So both entries relate to the same project.

 

this is what the query returns

 

$result = $sql->query($query);
$row = $result->fetchAll(PDO::FETCH_NUM);


Array
(
    [0] => Array
        (
            [0] => 1
            [1] => lab
            [2] => SBR
            [3] => http://sbr.9leaves.com
            [4] => 847587269-sbr_1.0__(1).jpg
        )

    [1] => Array
        (
            [0] => 1
            [1] => lab
            [2] => SBR
            [3] => http://sbr.9leaves.com
            [4] => 1273681671-sbr_1.0__(2).jpg
        )

)

 

it returns 2 sets of results. how can i combine it into one? basically the result array would have 6 elements, the 6th one being the second(or first) screenshot image.... idea result would look like

 

Array
(
    [0] => Array
        (
            [0] => 1
            [1] => lab
            [2] => SBR
            [3] => http://sbr.9leaves.com
            [4] => 847587269-sbr_1.0__(1).jpg
            [5] => 1273681671-sbr_1.0__(2).jpg
        )

)

[mikesta707]

have you tried array merge?

[play_]

No.

but isn't there a way to do it with the query?

[kickstart]

Hi

 

Use GROUP BY and GROUP_CONCAT()?

 

All the best

 

Keith

[play_]

I did try to group by projectID, but that didn't return expected results.

 

will read up on group_contact. thanks

[play_]

group_concat joins columns into a single string, so not really what i'm looking for.

[kickstart]

Hi

 

As it would seem otherwise you would want a variable number of columns for each row I am not sure how else you could do it. You can always use explode to split up the GROUP_CONCAT column within php.

 

All the best

 

Keith