Merci, je pensais que c'était faisable, dommage...

Bonjour tu ne peux pas faire en SQL. Tu dois passer par PHP : lorsque tu boucles les résultats de ta requête, à toi d'organiser tes données comme tu en as besoin.

Array(
[0] => stdClass Object
        (
            [id] => 1
            [address] => boulogne sur mer
            [lat] => 50.725605
            [lng] => 1.614883
            [type] => 1
            [id_marker] => 1
            [id_cpt_info] => 1
            [date] => 2007-05-03
            [titre] => Reg
            [commentaire] => test		

            [categorie] => 1
        )

    [1] => stdClass Object
        (
            [id] => 1
            [address] => boulogne sur mer
            [lat] => 50.725605
            [lng] => 1.614883
            [type] => 1
            [id_marker] => 1
            [id_cpt_info] => 2
            [date] => 2007-09-10
            [titre] => Régate DK
            [commentaire] => test2		

            [categorie] => 1
        )
)

Array(
[0] => stdClass Object
        (
            [id] => 1
            [address] => boulogne sur mer
            [lat] => 50.725605
            [lng] => 1.614883
            [type] => 1
            [grp] => Array(
                                [0] =>stdClass Object
                                      (
                                      [id_marker] => 1
                                      [id_cpt_info] => 1
                                      [date] => 2007-05-03
                                      [titre] => Reg
                                      [commentaire] => test		

                                      [categorie] => 1
                                      )
                                [1] =>stdClass Object
                                     (
                                      [id_marker] => 1
                                      [id_cpt_info] => 2
                                      [date] => 2007-09-10
                                      [titre] => Régate DK
                                      [commentaire] => test2		

                                      [categorie] => 1
                                      )
                                )

        )
)

Bonjour,
[b]j'ai une requête qui me sort ceci :[/b]
[php]Array(
[0] => stdClass Object
(
[id] => 1
[address] => boulogne sur mer
[lat] => 50.725605
[lng] => 1.614883
[type] => 1
[id_marker] => 1
[id_cpt_info] => 1
[date] => 2007-05-03
[titre] => Reg
[commentaire] => test

[categorie] => 1
)

[1] => stdClass Object
(
[id] => 1
[address] => boulogne sur mer
[lat] => 50.725605
[lng] => 1.614883
[type] => 1
[id_marker] => 1
[id_cpt_info] => 2
[date] => 2007-09-10
[titre] => Régate DK
[commentaire] => test2

[categorie] => 1
)
)[/php]

[b]et j'aimerai que ça me sorte :[/b]

[php]Array(
[0] => stdClass Object
(
[id] => 1
[address] => boulogne sur mer
[lat] => 50.725605
[lng] => 1.614883
[type] => 1
[grp] => Array(
[0] =>stdClass Object
(
[id_marker] => 1
[id_cpt_info] => 1
[date] => 2007-05-03
[titre] => Reg
[commentaire] => test

[categorie] => 1
)
[1] =>stdClass Object
(
[id_marker] => 1
[id_cpt_info] => 2
[date] => 2007-09-10
[titre] => Régate DK
[commentaire] => test2

[categorie] => 1
)
)

)
)
[/php]
La requête se fait sur 2 tables une "markers" (id,address,lat,lng,type) et une "markers_info" (id_marker,id_cpt_info,date,commentaire,categorie).

Est-ce que c'est possible ?

Merci d'avance.